The Met Office has issued a yellow warning for wind, which is set to impact the North East over three days of weather chaos.