It's all down to pumps really.
For a mains connected system, a mains pressure system simply means you are using the water company's pumps rather than yours.
For a well sourced system, I'd ere on the side of header tanks in the loft. To directly pump mains pressure water from a well requires you to measure the maximum extraction rate from the well to ensure that it's sufficient for your maximum demand (x showers, bath and washing machine, that sort of thing), then you'll need a big pump, appropriately sized expansion vessel etc.
With header tanks, you can get away with a small pump that can run as slowly as you want.
If you use a thermal store (as we have) all the sources (heat pump, wood burner, boiler etc.) all run at atmospheric pressure. The only component at mains pressure is the water that's consumed in the house. No need for fancy certificates or qualified heating engineers (at least as regards the pressure of the system.)
Not great on diagrams. Sorry. You might be able to glean something useful from
this dross.