You need 2 things
1: Valheim+ or a mod that enables first person view (or the camera stays over water)
2: The console command "debugmode" that enabled Fly with the "z" button

be carefull with landscaping under water, it can break the Water plane
https://steamcommunity.com/sharedfiles/filedetails/?id=2621856721