From Georgia Aquarium's 100-foot shark tunnel to a Connecticut facility where guests paint alongside resident seals