Stylized Waterfall

The VFX of RIME GDC talk is worth watching.

Also, take a look at this 2 part series by Rodrigo Villani, it sohuld get you up to speed on projection in UE4:

Then look at this short tutorial on using noise with the panner node:UE4 Flowing Noise Material tutorial - YouTube

These should give you a good idea of where to start and what to seek out to learn. Once you’ve got a grasp of the topics covered in those tutorials I linked, you should be able to take the code examples from the images you linked and recreate that in UE4’s material blueprints.

Good luck!