Does you provider offer an email to MMS connection? I know with my cell carrier you can email to (my phone number)@telusblah.com and it'll forward it as an MMS.

Here are a list of gateways that might be helpful for this: http://en.wikipedia.org/wiki/List_of_SMS_gateways

It actually already does support this, as well as twitter and push notifications to iOS via Boxcar.

Just click 'Add Alert Contact'. Also seems pretty granular about which monitors report to what contact.

An old classic is http://aremysitesup.com/. You could use that as an alternative.