Parts of Yorkshire could also see wind of up to 65mph as the Met Office warned of flooding and power cuts