Thanks to Charles for this discovery. PUI Audio makes a small programmable speaker that appears to be capable of receiving power from any standard LEGO® system: 9V trains, Power Functions, Mindstorms, etc... Just prepare a sound file you'd like it to play and load it via USB. Any time power is applied, it will loop the file continuously.

Available from DigiKey, PN 668-1213-ND.