gee...where does all that water come from?

Stating the obvious: Water flows downhill. As long as rain continues to fall above the waterfall then it will continue to flow because of the water cycle.No, there is no reason to suggest a waterfall will not continue to be a spectacular sight.