Any type can be an artist in different areas, you'll find singers, painters, musicians, writers, directors, sculptors, etc. of every MBTI type.
In general though, and stereotypically, it's ISFP, INFP, ESFP.
Then again, you can also find examples of these types who have absolutely no interest in artistic pursuits.
I enjoy woodcarving, does that make me an artist though? Probably not.