You will need to purchase a Cellular capable camera, one that has a cellular modem inside it which will connect to the carriers cell towers.
The camera's I have seen like this do not transmit real-time video, just a snapshot of the location at timed intervals. Transmitting live video, 24/7, over the cellular network would probably cut a big hole in your pocket.
They are also usually part of a "security package", I have not seen them outside of that.
The type of "surveillance camera" that you seem to have in mind would use the available Internet in the home, something supplied by your cable company usually, and would transmit continuously.
These cameras' can be either Wired or Wireless and have their own internal website that you would access from your phone. Multiple cameras would connect to a central point in the house and you would access the video feed there.
There are also various apps that would enable you to connect a camera to the internet.
P
Hello, I am not a tech person and I need a little help. I want to install a webcam/camera so I can view my property directly from my smartphone when I am away. I do not have wireless internet, WiFi or a router in the home. I just have my smartphone with internet. Is it possible to buy a camera that directly sends live feed straight to my smartphone device? Or will I need WiFi or a router for this? Is this possible, I read somewhere about a P2P connection and an ad hoc server? Can a home surveillance camera send live recording straight directly to my phone without WiFi or anything like that? I want to make sure that this is possible before I buy a surveillance camera. Thank you for your help!

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic