What about the Shurflo faucet 94-009-10?  I've used this for years without
problem.  It folds down nicely and can be installed with a couple of washers
and a piece of gasket material.  The contained switch controls the pump.  I
don't, however, use "City" water as a source.