Dum dum dum dum-de-dum dum-de-dum.
Leon Anavi has written an Instructable tutorial in which he takes a simple piezo buzzer, connects it up to his Pi and then uses C/wiringPi to play John Williams’ Imperial March. You can read the Instructable here.
A tutorial/demo video is available below: