It's still very hot up until mid-November. Then the cold fronts start to move in from the north and it might get as low as 65 degrees F. at night (but not every night -- 70 degrees would be more typical). The days will still be in the high 80s.
It does get rainy at that time of year, but it doesn't rain all day or every day. Rains usually come overnight or a brief shower in the middle of the day (again, not every day). You will see more clear, sunny days than rainy days.