Lot's of good stores here, avoid the PetCo's for sure. Everyone has their favorites so opinions will vary, but you won't get any battles here over it.

As far as shops that have tanks and equipment readily available, you can check out Aquarium Designs, B&B Aquatics (not on pet store list for some reason, but has their own forum in the sponsor section), Alamo Aquatics and even Texas Tropical. Phenomenal Aquatics (listed as Wolf Reef still on pet store list) is a good place to stop for live rock and livestock.