Skeletal Mesh moves with the camera movement

This is usually done using aim offsets. You can learn more about it here Creating an Aim Offset | Unreal Engine Documentation