Flooding has forced 43 people to evacuate from a Northamptonshire holiday park.