Woodland Scenics
I have used several products recently. There are two offerings from Woodland Scenics: Realistic Water and Water Effects.
Realistic water - good for small areas of water i.e. waterfalls or small pools. It\'s very runny and can be poured, however they recommend you do not use too much at one time. It does shrink back when dry and at deeper areas, will go cloudy until completely dry.
Water effects: Very different - it\'s thick and looks like PVA glue. You use it to create ripples, texture on waterfalls or splashes etc. It starts off opaque and drys clear. It has a rubbery feel to it. I recently used it and painted it to add to the effect I was trying to create.
Crystal resin - awesome stuff, but expensive. A two part resin which you can pour quite deep. It will dry crystal clear so is excellent if you want people to see into the water... A word of caution: it is very unforgiving and if you have left the smallest of holes anywhere it will find a way to escape which I have found to my peril

But it really does give fantastic results.
Example using realistic water. I had to apply several \'coats\' of realistic water letting it dry thoroughly each time. It does shrink back quite a lot during drying.
Example using water effects on top of dried crysta resin
http://slavetopaint.com/gallery/displayimage.php?album=91&pos=24
And finished result once painted etc
http://slavetopaint.com/gallery/displayimage.php?album=91&pos=25
The links above show a diorama I recently finished. There are more pictures than the ones I have shown here, but these show the products quite well. You should be able to see the other pics too.
Hope this helps
