This is a breakdown on how I achieve this materials in substance designer for my Dark Scifi environment. All these are done by me.
Environment post:
https://www.artstation.com/artwork/mqmzwZ
Video of the water flowing down decal. Now, I'll show you how I did it.