I know it’s not at all the same style but you should have a look at this amazing shader by @Mugen87
If you really want a realistic waterfall you will need particles, there is a couple options for you. You can create points and points materials like this or like this. Alternatively there is some libraries that could help you, like this one or this one.