It depends on the diameter and distance you're going, as well as your water quality.
If you're 4" to 20" in diameter and underground, HDPE is probably the best choice. It's corrosion resistant and cheap to install if you have an experienced installer with the right equipment. I assume you'll have fairly low pump heads imposing internal pressure on the pipe.
Above ground, you can get into either FRP, carbon steel, or galvanized carbon steel, depending upon water quality, economics related to the diameter and distance, etc.
I'd only consider PVC in small diameters