My ASUS G2S-A1, instead of a beep plays an explosion sound+animation. One would need to manually edit that section of the BIOS though.

The easiest way imo is to just change the windows login sound I guess. I dunno about XP, but in Win7 it is C:/Windows/Media/Windows Logon Sound.wav