Sustainable rural water management for sustainable agriculture