I\'d paint the water the colour you want to and then use a scenic water product to make it shimmer. If you want to sculpt some texture, like waves, I suggest using Woodland Scenics \"Water Effect\".. It\'s easy to use, and produce nice results.
You can also use PVA glue that dries clear.. and cover it with gloss varnish.