I'm not an expert, but it sounds to me like maybe you have too many things going on in your life, and you feel like you can't manage them all well.

Your wording: I keep having this dream, can suggest that the dream itself relates to a situation about which you have some persistent ?dream?, wish or fantaciful thinking. The situation appears to be one that is close to home and one that may require some evaluation. (i am in my yard)

Water itself is frequently seen as representing emotion but even more importantly it represents The Spirit and one?s spiritual knowledge and spiritual thinking. Water also represents the subconscious. Water rising up out of the ground can suggest that subconscious feelings are coming up ? feelings that may associate with spiritual thinking. The spiritual thinking here may relate with intuitively acquired spiritual knowledge. The effect of this happening is to cover the ground with water in what seems to be an undesirable manner (since your aim in the dream is to repair the underground leak) In other words, the rising water implies that your rational grounds of reasoning are becoming undesirably influenced by emotions and spiritual thinking which may be of an intuitive nature.

The digging implies that you are, and need to, be intent on revealing what was previously hidden from you. In this case what was previously hidden is represented by the underground pipes. Water pipes would refer to the spiritual system by which, or through which, you obtain your spiritual knowledge in a way that directs it toward the conscious, rational mind (represented by a house) The rusty pipes indicate a system which has suffered from lack of use. Your efforts to correct this system of delivery of spiritual knowledge seems to repeatedly fail. (I fix the leak and another leak starts)   

The pond of water would refer to a body of spiritual knowledge, in this case consisting most likely of intuitively acquired knowledge (as this water seems to have risen from below ground) As can be seen, this intuitively acquired knowledge appears to be undermining your house and your rational thinking. Note that this pond is not a naturally occurring pond but one created by a flaw in the system by which spiritual knowledge is brought to your mind. This means the pond is not a body of spiritual knowledge set up by God. Scripture emphasizes that a house should be built on rock ? solid truths of God. A mind or mental attitude based on water ? based on emotional or intuitive spiritual knowledge is not giving your rational thinking a very solid base. (a big pond of water under my house)