From the sunniest corner of Scotland to the sweeping sandy beaches of Northumberland, these holiday parks offer something for everyone.