‘Significant’ flooding hit Northamptonshire overnight causing an evacuation of the Billing Aquadrome.