I have a buddy that lives in Pensacola and fishes from a kayak alot in the bay there, he does great with reds and specs. You can fish from the beach, in september you will very likely see spanish mackerel schooling very near the beach. There is a pier in orange beach that has good fishing as well.
There is a party boat located at Sanroc Cay marina, Reel Surprise Charters if you want to go offshore. I highly recommend them, great people.
Dont waste your trip. currently only people with navy credentials can go.