You are correct in that a pump designed to handle 500' water level will "over-Pump" and potentially damage itself at 10' water level. The answer is a Constant Pressure system.
Grundfos has released their Smart-Flo Constant pressure system. This pump runs at different speeds depending on the...
My opinion on this (and the basis for my opinion are as follows:
Low Viscosity = 0 - 500 SSU (~100 cps)
Most Centrifugal pumps start to have serious degredation of Flow, Head, and efficiency over 500 SSU. The rule of thumb is over 500 SSU = don't use a centrifugal pump. Now before I get...
BronYrAur,
The magic bullet for you is the Grundfos MQ Series Booster Pump. It is an easy to install self contained booster pump that is specifically designed to boost low residential pressure. It does not require any kind of storage tank as it is an on-demand pump. It has a wet-rotor design...