Some pond owners that have a well, pump water from their well through 1 1/2 - 2" pipe. Apply ells and tees, connect a high pressure water nozzle, about it.
I don't have a well, so I purchased a lawn sprinkler pump that I bought from Lowes. I pump water from the bottom of my pond to the surface, into the air around 30' and let it splash the surface. I placed my inlet pipe around 12" from bottom of pond. I also used a check valve/screen at the end of my inlet pipe so I didn't have to prime the pump after turning it off, and not suck up leaves.
Wish you the best.