The Met Office has issued a two-day red warning for Wednesday and Thursday in the West of England.