I was there the first week of October this year. It was very warm, most of the bars were packed, and there was a lot going on. The water is always cold, compared to the gulf of mexico in summer, but its certainly warmer than most places in October.
ive also been in February. It was a bit chilly, but still fun.
ive been in March. It was comfortable but not hot.