A 12V submersible pump sits right inside the fresh water tank and delivers water quietly and compactly. It is the most common pumping solution in RVs with a simple water system. A matching pump is usually quick to swap.
Combined with a pressure switch, the pump cycles automatically and keeps pressure steady - more convenient than faucet-only switching.