august bank holiday weather forecast