Because Detection Tower’s last ability doesn’t change the characteristics of any permanents, the set of creatures affected by it is constantly updated. Creatures that come under your opponents’ control later in the turn can be targeted as though they didn’t have hexproof.

Creatures your opponents control with “hexproof from [quality]” abilities can be targeted as though they didn’t have those abilities as well.

Your opponents and creatures your opponents control don’t actually lose hexproof, although you will ignore hexproof for purposes of choosing targets of spells and abilities you control.