Hrm... Just rig a toggle switch to the power antenna lead, and that should be enough for your needs

Or you can also buy a head unit that wont up the antenna when the CD is playing, and power it up when the radio is used...