Any idea on how to recreate the the splurting effect on this water shader?

Unity Engine
1

Wanted to have a crack at recreating this texture from Ori:


Not the streaks of water falling down, just the splurting water inside the trunk. I imagine is some sort of texture scrolling + dissolve of some kind, but i’m not sure how to tackle it.
Anyone has any ideas?

Here’s the video with the whole scene to look at:

2

This is the closest i got so far, but it’s not really there yet

goodnastyheterodontosaurus