Irish Water needs to be abolished and have its responsibilities given back to local councils in order to save the taxpayer money, Fianna Fáil leader Micheál Martin has insisted.