A red weather warning has been issued by the Met Office as Storm Éowyn is set to batter parts of the UK.