Met Eireann issues urgent weather warning for two provinces ahead of torrential rain