Carlos Cardona shares this easy to make shader to hide submerged architecture.
Assets created by me, except the character and statue, blender and substance, this was perfect to use again this water shader, I really like how it looks the transparency.
In case you want to use this water shader, tutorial below.
I have a LONG history with Blender - I wrote some of the earliest Blender tutorials, worked for Not a Number and helped run the crowdfunding campaign that open sourced Blender (the first one on the internet!). I founded BlenderNation in 2006 and have been editing it every single day since then ;-) I also run the Blender Artists forum and I'm Head of Community at Sketchfab.
