How to get cameras local x-axis pointing up?
You probably want to use the "Track To" constraint. Then you can configure which axis should point to the object, and which axis should point upward. For a camera this would be typically -Z for the "To" axis, and Y for the "Up" axis: