I’ve been looking into DIY off the grid living a while now. One method that could be fudged into the game is a gravity well.
Have your living space under whatever tank or water catch you have. The water gets filtered through inline filters. You can actually do this with charcoal(the crap you make) for a shower or something. A better filter for dishes and consumption.
Truly it isn’t all that difficult unless you want to a very instant filtration of potable water.
For storage in tanks. You also add bleach depending on the amount held in the tank.
For water pressure that is a little more tricky if not using gravity. You either use a mechanical pump and manual labor. Another method is using an engine. But the less crap you have to rely on, such with an engine. The better off you are. Manual and/or gravity are best methods.