Just following up on this since LDC has their boat schedule up.
I'm not sure when exactly you'll be in the neighborhood, but the Morgan, Brass Spike, and Gulf Hustler are going to be the best dives we see in July out of LDC (in my opinion).
Dives like the Tiger, Santore, Tug and Tower are decent if you haven't done them. They are fairly shallow dives, visibility usually isn't much beyond 20 feet on a great day. Pretty good if you want to do some spearfishing or lobstering. Not much in the way of stucture, mostly debris fields for the Tiger and Santore. The tower is the Chesapeake light tower. Underwater it looks like 4 giant pylons extending down from each corner of the light tower with braces between the pylons. It attract some marine life, it's hit or miss, but in general it's a nice relaxing, get under the water, dive.
I haven't done the LC or EB Barges that I'm aware of, though I expect they are decent spearfishing spots?
3rd Island is a good dive to spearfish.
Captains Choice is hit or miss. I only say that because if you pick a dive to the Tiger the week before, and then you get in on a captains choice and they decide to go to the Tiger, well, I kind of consider that a miss.
The Dives are 2 Tank Dives, there is no longer a compressor on-board so you will need 2 full tanks. The shop of course has tanks you can rent and they do fills at the shop including mixed gasses. Outside of tanks you can rent anything else you need there except personal gear like masks, fins, wetsuits, booties. They rent out Scubapro gear.
Other than that, there are other dive shops and boats in the area that will be going out, but logistically you may find LDC to be the easiest to deal with. Just as an example, if you do any spearfishing, you don't need a personal license when diving off the Miss Lyndsey out of LDC. Some other boats in the area do not have fishing licenses so if you want to spearfish, you will need your own license. Little things like that you may encounter. LDC pretty much has all the little stuff taken care of.
Oh, I know you mentioned inland dives. If you are going to be in the actual City of Norfolk or Virginia Beach then you might as well hop on a boat. The quarries are all quite a bit of a drive, and there is nothing really worth seeing. If you are up for that kind of drive, why not extend it a bit and really get some great dives in down in Moorehead City? It would be a good option if you were closer to the quarries, but, not much reason to leave the ocean to go to the quarries unless you aren't much for boats.