Dreams of a waterfall or rapids may be referring to birth, especially ones in which you are swept along in a warm stream of water through a tunnel and emerge into a pool or lagoon, as it is thought that we all carry the memory of birth in our unconscious. On the other hand, the dancing waters may be reflecting your sense of happiness and exuberance in waking life. A dream of a fountain (suggests womanhood) or a hosepipe (suggests manhood) may have a sexual connotation.
If the jet was weak, then it may suggest that sexual desire is not matched by emotional commitment (or the other way round) A steady flow of water is probably symbolic of confidence in waking life.
In dreamland, springs can represent a source of untapped creativity and they can also hint at wisdom, because another name for spring is fount, suggesting ‘fount of all knowledge’. Wells in dreams can hint at emotional rebirth or good fortune, as wishing wells have been credited with wish- fulfillment for centuries. So if you dreamed of drawing water from a well, what is it that you long for? Because wells are sources of water, it could be that your waking life has become emotionally dry and that you are thirsting for a revival of feeling.
[1]