A pipeline drawing water from the Shannon is the only solution to the threat of drought and taps running dry in the east of Ireland, the head of Irish Water has warned.