Sounds like the trip of a lifetime.
If you're spending the night in St. Pete, I would stay at the Tierre Verde Marina. It's protected, but is near the gulf. There's a lot going on in the vicinity. There's a neat little bar there and there's also quite a nice club.