Hello, I am not a pump expert. But for general application, centrifugal pump would be one of the best and would work better in positive suction head. Simple, cheap and robust.
For pumping from a well, submersible pump, whether oil free or non-oil free(rare, nowadays)would be the way the go.
For constant metering of fluid, peristalic pumpset with tubing being squeezed by a cam.
Progressive cavity pump would be for abrasive fluid such as sludge and lime but the problem of clogging would still persist if not periodically flushed.
Most pumpsets can be driven by VSD(variable speed drive) for coping with flow and pressure head.