Is this possible?

Is it possible to zoom in only part of the screen?

yes

How would one do this?

Normalized Viewport Rectangle

can it be a circle by any chance

http://answers.unity3d.com/questions/33079/can-the-cameras-viewport-be-non-rectangular

Here ya go