I've been considering a co-housing project and one thing we're concerned with is water.
Trev, this might interest you- a complete sewage treatment plant system:
https://completely-green.co.uk/green-technologies/off-grid-home-systems/off-grid-waste/