Alarm systems for the home or buildings have siren drivers and speakers which will operate on 12v battery power. You should be able to buy just the siren driver separately, and get a small horn speaker for it. You will need to make a switch circuit to activate it.
They can typically be programmed to output a wide selection of siren output sound types.