Water being used ‘faster than it can be replaced’ as Met Éireann predicts ‘tropical nights’ and heatwave temperatures of 30C