I don't know how "mermaid-y" this is but the Moody Gardens Aquarium is really nice. You could check that out.