Water levels on the River Don in north east Scotland reached their highest levels in 45 years during a night of severe floods caused by heavy rain.