Here are a few pumps I have been testing. Some use DC and some use AC.

If using an AC pump in an off grid location, and inverter will need to be used, in addition to a battery and charging system (solar, wind, etc...).

If using DC pumps, it is possible to connect them directly to a solar panel (if the solar panels match the voltage of the pump), but adding a battery will help the water flow more consistently, and can also be better for the life of the pump motor.

Pumps in this video range from $40 - $300 each, here are some links:

115v AC 330GPH Pump
https://amzn.to/2TR9XlY

115v AC 1/2 HP Pump
https://amzn.to/2TRG70U

12v/24v DC Submersible Pump (mid range)
https://amzn.to/36MjAbc

12v DC Submersible Pump (cheap)
https://www.ebay.com/itm/DC12V-Immers...