Thunderstorms and heavy rain will persist across parts of the UK, as summer officially comes to an end.