Well, MSD sells an RPM-activated switch. People used to use them to activate VTEC in swapped cars back in the day before things like using a VTEC ECU became commonplace. I don't see why you wouldn't be able to wire some kind of buzzer into that.