You can put an AIFF or .snd file in the ~/Library/Sounds folder (in your home directory), and then choose it as the system alert.
Maybe you can even use any Quicktime-recognized file, I dunno.
If ~/Library/Sounds doesn't already exist, just make the empty folder, and put the sound in.