How to create Flip water simulation on curve path in Houdini with foam emission

Hi,

I'm trying to create a water sim resembling water bending in the movie "Avatar the last air bender". I want a huge continues flow of water with foam emission in a specified path and in the end to fill a lake (container). Foam is must to be included on the water surface.

Thanks in advance