Red weather alert issued across parts of UK ahead of powerful Storm Eowyn