Simplest way is just to go into avast's Program Settings, select Sounds (about halfway down the menu) -- there's a tick-box for "Disable avast sounds".
Or if you want to hear something but just hate that siren, go into Control Panel and select some other sound file for the "Virus found" event.