Modelling realistic water is easy if you have the right glue...
This guide is about creating water itself. Make sure to check other guides on this website that use this technique for complete projects: river and sludge, puddle/mire/lake
I don't use ready-made modelling water as it is expensive and actually worse then a glue covered with varnish.