I just use my big shop compressor with a inline air regulator that I installed and also a inline filter so no oil or water gets in there. Works good, I can spray for quite a while before it turns on, but when it does it always scares the sh** out of me haha. I have a 6 gallon shop compressor, I had a smaller one first which worked but was always turning on and was difficult to regulate the air. I'm working in my shop, so noise isn't a factor. If you are doing it in your house or somewhere noise matters, look into one of the on demand air compressors for airbrushing. I don't have any experience with those.
Welcome to Tackle underground by the way! Everything I learned was basically off this forum, and youtube videos. Lots of good help here. If you use the search function, there are many good topics already covered in the past too!