It's too bad I'm not rich. If I were, I'd get a custom framed bike, have the top tube welded shut at each end, and made air tight. I'd tap it with a valve and fill it with liquid CO2 to run a horn like this.

I'm thinkin of one, if only the horn didn't look so freakin goofy.