weather forecast for august bank holiday