The one I described could be made pretty cheap, with the relay or SSR being the most expensive part.
Any DC source, wall wart or battery would work and if your noise maker was also low voltage DC, you could eliminate the relay/SSR and put your alarm device there. This design turned on 120v flood lights and a claxon via the relay.

[Linked Image from gfretwell.com]


Greg Fretwell