So I thought I had better have a go.
I wanted a more 3d waterfall than Dunes plane and cloud method, so I used a simple shape shader. It was bent at the top with the twist and shear shader and distribution shaders. Two layers of cloud were added, bent with vector displacement shaders, warp and distribution shaders. A big thanks to Dune for the tips. A third layer of cloud at the base was added for the foam
I first tried to use transparency in the SSS but the render time( 3 transparent layers 3 lots of clouds) was out of this world! so sadly that had to go. The stretching of the textures on the SSS also made life difficult. However I'm content with the result of these tests and will keep playing to try and improve them as I go along.
