I run mine at around 50psi so you would want a compressor that can achieve something higher than this. You also want one with a tank rather than a directly connected one (usually meant for inflating tyres). You might be able to use one of those small airbrushing compressors, but they have tiny tanks which means they will be constantly turning on and off to replenish the air pressure in the tank. I'm also not sure how quiet those are and all the prices i've seen have been more expensive. My compressor has a 21L tank, and a 2.5hp motor good for 95 litres per minute airflow. Takes about 2-3 minutes to completely fill from empty, and will turn itself on for ~30secs when the pressure drops too low which is about 10mins of working. Solder dispenser will still work for a fair while longer if the compressor is turned off, as the compressor fills the tank to ~120psi (turns back on at 100?) and I only need ~50.
If I'm doing a lot of work, I just use a 20m air hose, and leave the noisy thing in the garage
And yes, you *will* need an inline air drier/moisture remover. Mine cost ~$15. It will remove any oil that's been leftover in the tank as well as water vapour from the intake air that has condensed.
If you are going to buy a proper compressor, get one with the biggest tank you can afford. I regret not getting the 40L model which wasn't that much more expensive.