Environment Minister Phil Hogan has said that more money will be invested into the Irish water system so councils do not experience shortage problems.