Answer :

"My favorite tropical fish's fins almost seem to glow in the water" is correct. The apostrophe is placed before the fish here because you're referring to a specific type of fish, so it is singular.