Most provide pickup. I know Captain Bryans Stingray City Trips in Grand Cayman has an office a few blocks from the terminal. We just walked over and they drove us to the dock. I think many do make sure you can get there as they understand that you don't have transport:-)