Modder Gorgulla has released a new mod for Fallout 4 that overhauls its water and all liquid effects. This mod also adds reflection to effects that didnt have any reflection before, and covers the water-shader that is on objects when it rains.
Source: N4G PC Fallout Water Overhaul mod significantly improves water and all the liquid effects in Fallout 4