Community water management