In these still largely prosperous rural heartlands, filthy water has become a surprisingly powerful symbol of national decline, says Guardian columnist Gaby Hinsliff