If you're just looking for a way to enlarge a portion of an image, there are lots of solutions available.
But, if you're looking for the "movie effect" -- where they zoom into a fuzzy part of a picture, say a satellite photo, and then they can read the license plate of a vehicle! -- that is know as "special effects" is just that, not real.
An image has only so many pixels. And while you can make them larger in size, you can't break them up into smaller pixels in order to see more detail than in the original image.