First, as
@Plungee mentioned
The Oriskany is actually nearer to Pensacola, which is another 2+ hours west of Panama City Beach. An aircraft carrier, it is the largest artifical reef in the world, and on good days it is far enough out that you can have blue water and nice viz (neither common closer to shore in the Gulf). I'll respectfully disagree with some comments above -- although the flight deck is beyond recreational limits (around 140+ feet), the ship is huge and to me there is plenty to see within recreational limits (most shallow is around 85 feet I believe), and there are really colorful sponges and corals encrusted on her, and a lot of creatures on and around her. Nitrox is really a must, and we were able to request 27% from our dive op, which gave us a good MOD. It's a long ride out and back, but a cool dive if the weather cooperates. For me, it was good diving, bit of a bucket list item, but I'm unlikely to go back often because of the long boat rides, somewhat short dive times, and it's a bit pricey.
Panama City Beach will be a good bit closer for you. Unless the stars align you will likely have green water and somewhat lower viz. Though I laughed the first time I heard it said, it is true: if you can get past the viz, it's good diving. There are a good number of wrecks/structures (bridge spans, navy towers, etc.) and there is a lot of life around them -- from some cool macro critters to sharks, to Goliath Groupers (not rare to see). Most dives are descending down a mooring line to the wreck/structure and returning up the line -- no drifting. We've had good dives both with Dive Locker and Panama City Diving. Last I checked Panama City Diving was the only boat dive op who also provided guided shore dives at the St. Andrews Jetties, which can also be a good dive. Diving in PCB can be fun, you just have to be clear going in that this is not going to be the kind of blue water, great viz diving you have had in the Keys. I have not been diving near Jacksonville, but my research makes me think I would rather go to PCB. My son's pic from one of our PCB dives: