A cold snap which saw tens of thousands without power or water is coming to an end, the Irish national weather agency said.