Electronic device that can pick up on audible alarms in house, to be used to trigger other action?
This might be useful for the audio frequency sensor: http://www.convict.lu/Jeunes/Spielberg/Spielberg.htm 

The issue is that you do not want to activate it from other sounds and have to just detect a particular sound frequency.The above sensor/circuit can be used with a micro like an arduino or anything you are comfortable with a GSM Module(which will be the expensivev part) to send SMS.