How well does an in-ground pump do in a large kio pond and you are looking for the big spill because you have a 30ft waterfall?

It should work OK. The only thing you may have to do is put a valve on the outlet side to decrease the water flow rate if your pump is too strong. You will need a high head pool pump with a non return valve.