Personally, I like my double action airbrush I like to have control over both air and paint, but I still use an old fridge compressor with a water trap, given to me by my father in law some 20 years ago and still going....
You need to look at various options and advice before going ahead, but buy something decent to start with provided your wallet can stand it, and practice practice practice!!