Warm weather makes for glorious weekend – but heavy rain on way to north-east