Share of dug wells, which can't extract water from greater depths, has fallen by over 20 percentage points in two decades.