In the arid north-east, the towns monopolise the running water while the villagers dig ever-deeper wells, in a race to the bottom that portends Europe’s hotter, drier future