I have some Woodland Scenics EZ-Water with which I am experimenting. It seems pretty good as long as you follow a few basic principles (for example, it seems to flow massively better if the surface is prepared with PVA and allowed to dry first, and this also prevents dust floating off and spoiling the surface). Underwater weeds are particularly easy, just lay in some Games Workshop flock "grass".
For ponds, it would appear to be absolutely perfect and dead easy to use.
So that is one water technique that seems to work, and there are many others described on the interwebs.
My question is, can you get surface effects (ripples, foam, splashes) with the EZ-Water, or is there a better product for producing flowing water effects?