Storm Bert: Red weather warning issued for two counties; six counties under Orange warning for rain as Met Éireann warns of ‘damage to homes and businesses’