I don’t know of any magic formula (the look you want changes things) other than transparency with refraction and some reflection. Fresnel in the transparency can be good since water is more transparent if you are looking directly into it rather than at an angle, that is more of a big body of water thing though.
Try dissecting some of the shaders that are out there, you might want to look here https://www.maxon.net/~deepshade/ the shaders here were done mostly a long time ago but they are still good as examples even if they might be built differently now.
https://www.c4dtextures.com/modules/rmdp/
https://www.c4dcafe.com/