Get the app named Boxcar and have it send you a notice when something happens on Twitter. It has its own sounds inside Boxcar and you can pick something different in there.
Then (and this is the important part) turn OFF the notifications that Twitter used to send you. Otherwise you'll get notified twice when Twitter and Boxcar both tell you about new tweets at the same time.