After seven straight days of triple-digit temperatures, clouds and showers offer Houston a much-needed reprieve