Is there some kind of particle/visual effect/way to achieve something like a realistic waterfall in Godot's 2D?
It depends, what sort of game are you making? If you're making use of the tile system you could do animated tiles, otherwise an animated sprite would work best and then you would place it in such a way that fits your scene.
