Practically speaking for small quiet shop type compressors, as far as I know you're pretty much looking for Jun Air (buy used) or belt drive. You can slow down the belt drive compressors to a point to quiet them further with a smaller motor pulley, but you need a minimum RPM for proper splash lubrication, and enough belt wrap on the motor pulley to actually transmit power, some stock ones I've seen are about as small as you can get already.
The automotive guys I know will typically put the main one in a closet, little enclosure outside the building (bad idea with close neighbors), shed, garage attic, basement, etc. Just separating yourself from the thing with a wall or two helps a lot, running an air line is pretty cheap.