Over a decade ago, plans surfaced suggesting Dublin was going to take water from the Shannon. It wasn’t a joke, writes Caroline O’Doherty