Check out the camera prefabs that come with the free Unity standard assets- you can get this kind of camera if you use the "Free look camera" rig then adding a "mouse rotator" script I believe its called to the camera- thats included with the standard assets as well