When is he coming to town? It it's this weekend, there is a great deal going on with A1 Scuba and the Aquarium this weekend. They are offering dives at the aquarium for $60.00 per person (usually $175.00).
If he is not around this weekend, I would still recommend the aquarium. We did the shark dive and had a great time! It's a little pricey, but it was worth it...to us, especially in the middle of winter and we were dying to get wet and see some fish.
Aurora is fun too. The water is a little on the cooler side. I haven't been out there since the beginning of June, so don't know the exact temps. If there are a lot of classes in the water it can get pretty mucked up and the vis goes WAY down. There is an airplane that you can surface swim to the buoy and then descend on the line. It's pretty eery on a low vis day. Price to dive there is park fee ($6.00?) and key to scuba park (another $10.00...I think) but pretty low.