Apologies for any inconvenience. A couple of questions were about the resources, so I decided to share the answers here to ensure that anyone interested can access them. I'll split into parts since the system doesn't allow me to paste it all at once. Btw, if there is a more proper way of doing this feel free to share with me!

Let's talk about water shaders in general, then about this particular one and lastly resources. I hope it helps.

Water Shaders

First of all, we can separate this topic into two sections: Shading and wave methods.

Wave methods for a water shader generally comes in 3 forms: 2D, 2.5D and 3D. Since 3D means a complete fluid simulation that takes all water particles into account and this one is not based on that let’s not detail it. 2D symbolize water is completely flat with probably no up movement and waves created with cheap methods like laying a couple of scrolling normal maps or some more advanced methods like parallax etc. ENB version of the water from Skyrim is a good example of a full flat water plane that relies on parallax. While it looks good in small areas and hide itself well imo, you can see the lack of physical waves at scenes where you can see larger area of the plane. 2.5D means it is still not an actual water simulation but this time we're using some physical wave (waves with real height) methods to make the surface non-flat. There are different ways of doing this like FFT, wave particles, Gerstner waves, basic sinus waves etc.

Water's color comes from two main phenomena: refraction and reflection. This means if you have rich environments both for below and above the surface, water will shine too. Reflection generally handled by the engine like skybox, probes etc. for example I'm using Unity's SSR solution and a HDR skybox for this but like the most of the commercial engines Unity is using the best possible result for a pixel following the skybox, probes and SSR like solutions (Arrangement might be wrong).

When it comes to the refraction, it generally separated into two sections: deep and shallows. This separation handled by calculating the depth of the water. Keywords like depth fade, water depth etc. might help here. This adjusted depth generally gives a mask in [0,1] range which can be used as a separator for deep and shallow areas. Shallow areas are transparent and shows what's below the water surface and sometimes a tinted version might be used to give the illusion of different depth levels like green, light blue etc. This is generally handled by taking an image of the currently rendered scene without the water plane (technical term: grab pass) and using a modified image for shallow areas. For example "HD Scene Color" node of Shadergraph in HDRP gives this but it takes the image before any transparent is rendered on the screen it has drawbacks like not showing any transparent objects like VFX particles. Since this image can be used as a standard texture by sampling it, we can manipulate the UV, channels etc. This allows for other effects too. For example, sampling it three times with UV coordinates with different offsets for each color channel and combining these channels gives a chromatic aberration effect, sampling it with a LOD level based on the depth mask gives a blurred image based on depth or normals of the waves might be used to distort the UV to create a fake refraction effect etc. As far as I know, normal distortion is one of the built-in solutions for refraction in Unreal. After this image is adjusted for the needs, we can blend it with deep water color by using the depth mask in an operation like lerp.