I made this waterfall in a stylized style to cement my knowledge in combining Particle Systems, shaders and simple meshes to get the best possible result.
I built the shaders from scratch: the "stream" can be easily reused, while the "puddle" is a bit more specific for the effect.
The mist spray is a combination of simple droplets and bigger scrolling noise quads.
In the future I can definitely build a less tailored shader to fit multiple meshes for both falling streams and horizontal planes.
The "mist" component of the particle stack can be made larger to also suggest a tranquil sauna environment.
The resulting effect with a slight bloom