The last long weekend of the summer gets off to a very wet start with heavy rain expected for millions of Brits.