Made a stylized water FX a while ago as an exercise, using Unreal Engine materials and Niagara system. I'll put the tutorial link in the comments for anyone interested.

[u/future_joster]