Looks like you've gotten a lot of good responses about jobs in general

So I'll try to help as far as 'artsy' jobs are concerned XD
It depends on what kind of 'artsy' you're talking about. A lot of visual art careers will likely be surrounded by liberal/open minded people, but you know it depends. From my experience, most people I have encountered are very open minded and I have yet to come across anyone who would take issue with it. Granted I am a freelance illustrator, I am working full time for an independent game company right now but still freelance, so it's not as if I go to a workplace and deal with coworkers and such every day. But those who I do work with, and communicate with via phone and voice chat, have been perfectly fabulous about it.
But you know conservative and/or uneducated/misunderstanding people are everywhere. The fields of art extend far and wide. When I was in school my work was heavily influenced by gender variance and general LGBT themes, my professors were all seasoned artists and art directors, they seemed to think I would have no trouble save from exclusively religious companies. If you're looking for somewhere to apply that will be more likely to be accepting, I think where art is concerned it's fairly safe to say it's common sense. If you're going to apply to something more like a family arts and crafts type store as a clerk, or an art museum or gallery that is conservative, it seems more possible you could run into trouble. Just because it's an artsy type job doesn't mean anyone and everyone there will be accepting, but I doubt you'll have so much trouble you won't be able to work at all