The UK's summer-like temperatures are set to come to an abrupt end over the bank holiday weekend.