First off, the yellow wire goes to constant power, not acc. All IP-Bus devices are switched on/off with a signal though its bus cable. The adapter draws very little power and will operate perfectly fine off of the power/ground wires in the radio harness (which will match colors on your Pioneer radio harness) The iPod adapter will not show up as an external source unless the iPod is physically connected to the dock cable.
As for your other problems after you attempted the install, what wires did you attempt to connect to? If you went any further than the radio harness, you made the install tougher than it needs to be. Where did you hear the described noise coming from?