I want to make a small waterfall for porch
I've just made one out of garden ceramic container,just put a solar pump in as long as you get the sun ,it makes a nice little splash.
Here is some inspiration....
I like the solar pump option. The vessels need to be waterproof so the thing doesn't leak and waste water.