The standard (free) night water prefab is basically just a solid color with some weak effects you can barely see. Where can I get some better ones? Google doesn’t seem to be helping.
You must buy the pro version for realistic water effects 
Have you tried the new Water3 prefab? Even the standard version is pretty nice, way better than the old water.
Theres a few ones released by some other users like an ocean water prefab thats similar to the water3, but yeah take a look at the new 3.2 unity water, its amazing… the best ive seen in unity