I’ve used polyurethane varnish with good results in small still water features like drainage ditches. In many locales, tannin in the water gives a yellowish/brownish tint to the water. In any case, if you’re modeling anything other than clear mountain streams, this method might be something to consider.
If you’re looking to build up a thick “water” layer, I’d use a different method.