#8 Realistic Water Textures
Download it here.
Now that you've made the game all nice and pretty with the Skyrim Enhanced Shaders, you'll want to grab Realistic Water Textures by isoku to make the world come even more alive.
As you can see in the video above, this mod completely revamps the way water is presented in the game. No more jelly water.
The mod comes in different versions—notably 'crystal clear' and 'vanilla underwater'. I personally use the latter, but if you like looking at riverbeds, you'll want to go with the former setting.