Two people are killed and more than 800 homes flooded following heavy rain and high winds across England and Wales.