WET & Natural and Atmospheric commonwealth Patch
Simple as that, Changes the reflective light values and so on to NAC Values whilst retaining the waves etc.
NAC - http://www.nexusmods.com/fallout4/mods/7657/?
WET - http://www.nexusmods.com/fallout4/mods/20775/?
Suggested Mods
Water Enhanced
http://www.nexusmods.com/fallout4/mods/3281/?
For crash fixes in Nuka world delete "WaterTileHumpy_n.DDS"
This is by far the best I've seen the water in game.