With my Fall 2011 MBP, it's the wall wart that produces a wide variety of sounds depending on the CPU load.

Desktop motherboards are known for high-frequency sounds in response to varying load - the source are the low-voltage regulators for the different CPU domains.