That depends on the kind of art you're considering. 3D? 2D? And what style, pixel or vector? I've done everything from drawing in Inkscape and painting in GIMP to hand-coding SVG files and using pre-rendered POV-Ray scenes. Other developers have been successful with scanned pencil drawings. So think about your goals and preferences.