Yes, i know lots about these.
And this is the way the do most city water.
That big water tank you see is at a certain height above the houses to provide a certain amount of pressure.

But, i am too tired to figure out what you really want.

So view this:
https://www.thesurvivalpodcast.com/solar-water
and look at this kickstarter
https://bit.ly/kick-mills