A holiday park in Northamptonshire was evacuated after being surrounded by floodwater.