The Cathedral Concept is a comprehensive visual overhaul for Skyrim. It is simply designed, consisting mostly of retextures and improved models, so that you can use it as a foundation without having to worry extensively about compatibility. 

• No issues with lod tiling or mod incompatibilities.
• The water-edge bug has been fixed by setting water fog and reflections to start at the water line instead of mistakenly before. 
• Rivers appear much more realistic, in part because the shores and riverbanks now have calmer and more transparent water, as opposed to high specular and large obvious waves previously passing through them at unnatural angles.
• Water audio has been added to certain water sources inspired by RW2. 
• Compatible with any weather mod, though designed for Cathedral or Obsidian Weathers.
• BC7 compressed resulting in negligible compression artifact. This does not increase memory usage but greatly increases quality given the nature of the textures. 
• Cathedral Water can be installed or uninstalled safely at any time during your playthrough. 
  

Compatibility

• Simple design allows for great degree of compatibility. Edits only textures and water records (which control flow, water color, and audio).
• Compatible with audio overhauls
• This mod edits water records in the esp file. If you like how this water looks, I recommend that you do not use other water mods. 
• You can make compatible with iNeed by adding the "cause damage" flag to the water records. 
  

Requirements
For SSE Users: SSE Engine Fixes is required to fix the vanilla water reflection bug which casts black-rectangular reflections from tree LODs.