Depends on your preference for realism or just creating the appearance you prefer. If going for realism I suggest darker colors since from a distance, with some exceptions, most large bodies of water appear darker in color.
Small streams, running brooks, etc.......... totally up to your preference as you can see blue to almost black......... take a picture of something similar to what you are modeling and copy the color would be my suggestion.
Mark
