Water

Detailed Snow – Cycles + Microdisplacement
on this material it’s important to have adaptive subdivision enabled and use the microdispalcement control on the material to get the best result
It is also not recommended for large surfaces, only for close ups because the processing time can be quite high. You can still use it if your system can handle it.

Ice – eevee/cycles

Animated Rain – eevee/cycles
Animated Rainy Window – eevee/cycles
Animated Caustics – eevee/cycles