http://www.emergencyemail.org/

I use this. It sounds like exactly like what you want. For instance when I Tornado Watch or Warning is issued I get sent a text message with the EAS Alert from the NWS. It works nicely.