The best thing to represent water is clear acrylic resin. You can get it in craft stores in the florist area. Florists use it to make fake water for flower arrangements. For the flowing part, cut a piece of clear sprue to the shape you want the water to be, then cover it with the acrylic water. You may also have to use some clear resin (think the two-part, 5 minute epoxy in a syringe from a hardware store) and use it to "sculpt" the flowing water. It works better since it sets faster than the acrylic water.
Gino P. Quintiliani - Field Artillery - The KING of BATTLE!!!
Check out my Gallery: https://app.photobucket.com/u/HeavyArty
"People sleep peaceably in their beds at night only because rough men stand ready to do violence on their behalf." -- George Orwell