South Yorkshire's not that rural, compared to the wilder bits of North and East Yorkshire. Penistone and Barnsley are both in the Sheffield travel-to-work area so I doubt they're depopulating fast enough to decommission water mains.