A status red rain warning has been issued for two counties in Ireland as Storm Bert is expected to hit the island this weekend.