Bottom-up integrated approach for sustainable groundwater management in rural areas