My go to material for modeling water is acrylic gloss medium - which can be mixed with acrylic paint to get whatever color is desired. A cool technique is to layer the gloss medium with successive layers and tint the layers differently, say blue, then green, etc.