Here's a good look at a water wheel pump that moves water without the need for an extension cord.
Don't be fooled by the slow movement or the fact that this pump isn't blasting water through it at some mega PSI. This is human ingenuity finding a way to do work and help get us off the grid.
Take a look and see how this thing is built and how it works. We may need something like this someday.
This waterwheel pump doesn't come with specific building instructions, but the general idea is there. The concept is to use the energy of the flowing stream to spin the wheel and gather water into the tubing while lifting it higher than the outlet pipe. The bigger the diameter of the wheel, the better its ability will be to pump the water uphill.
In any event, moving water may be a moot point without conservation efforts. Our ability to save water has to be the first order of business; we can decide on how to move it later. In cases like California and their recent water restrictions, the moving of the water supply and the waste of it is part of what caused the problem in the first place.