If you want to pump water to create a cascade / waterfall of a given width and height 120cm, the pump you need depends on the width as follows Mains powered water features allow for prolonged use. Mains powered water features will work in any weather and in limited sunlight.
eBay