Without a local internet connection, you are talking some custom stuff. The Mobotix cameras require an internet connection, if you can connect it, then its easy to set up to email a picture of events or just an alert so you could then connect to the camera on line and view the event. They can be powered by 12VDC and they can have output contacts to trigger another device, but I don't think you'll find an easy way of getting a camera to interface with a phone.
You might need to find a smart phone with a camera and maybe you can customize it to do what you want. That's the route I would head down, unless you know of a way to get a remote internet connection (think mobile hot-spot).