Met Eireann issues urgent weather warning for heavy rain affecting three counties