Water – way to trace water pipes through walls

Yes, typically houses in northern (freezing) climates have an indoor shut off. When winterizing your house, you should turn the indoor valve off, and leave the outside one open so that the water can drip out. The danger is that the water can freeze and burst the pipe.

I'd look for the shut off in the basement, on the other side of the wall where the outdoor faucet is. Trace the pipe back until you find something.

These ventilation bricks were intended to prevent gasoline fumes from accumulating. The CO danger was not the concern as one should only run the engine when the door is open. Modern cars should not emit gasoline vapors in any significant amount, so such vents are typically no longer required.

Additionally, since the study cannot harbor a motor vehicle, such vents just make heating and cooling less efficient, so you would do well to cover them. However, habitable rooms must have some kind of ventilation, typically operable windows. An HVAC system running on fan mode is usually a legal alternative to windows, but windows also provide highly desirable natural light. Which is also a requirement for residences. The usual requirement is 1/10th the floor area for light and 1/20th for ventilation.

BMitch raises a very important issue regarding CO. I've seen offices adjacent to maintenance bays where although the adjoining wall was well sealed to the surrounding structure, exhaust fumes still managed to permeate through somewhere enough to be bothersome to the occupants. Take every measure you possibly can to seal the adjoining wall. It's too easy to overestimate how well a wall serves as a barrier. In addition, be sure to install a CO detector in your study just to be safe.