Can a career counselor help guide me into help with college?

A career counselor can help guide you with career choices that would be best for you. If you love art then go apply to a community college and take some art classes.

It's ultimately your decision as to a career path, but with regard to LVN or LPN, please be aware that jobs may be mostly found in a nursing home or long-term care facility.  The LVN curriculum is supposed to be rather intense, and the student is supposed to be adept in science-related classes.  I'm presuming that the LVN should know as much as the RN (registered nurse), even though they have some different job tasks.

If you're going to choose a major in for fine arts, for instance, perhaps you can minor (or major) in business.  You're right that the art industry should be *very* competitive, and work may *not* be steady.

The "county" public vo-tech school may offer LVN or other career-oriented programs.  In addition, the local community college may have similar programs and/or classes through the "non-credit" or "continuing education" listing.

Please keep doing your research and due diligence before taking pre-req classes and/or signing up for a program.  Doing some "job shadowing," such as a LVN is generally recommended too.

For more general career info:

https://www.bls.gov/ooh/ and can type into search.

With regard to an Associate degree in psychology, that's basically like a liberal arts degree with some psychology courses.  The same or similar may be said for a bachelor's degree in psychology, but such a bachelor's degree *might* help one to get a job as mental health technician, psychiatric technician, or a human resources (HR) assistant, for instance.  However, the latter may *not* have too many jobs, and those in HR tend to be one of the first to get laid off if cutbacks are required.  

A bachelor's in psychology tends to be a starting off point for a graduate school, such as for a master's degree and/or doctorate (PhD or PsyD).  Most jobs for licensed psychologists require a doctorate too. 

Sure, you can pay a career counselor to talk to you and administer some aptitude tests to see what makes the most sense. This is not the same as a guidance counselor at a college.  

You can also think about a few things first:

1. What, exactly, is your goal in going to school? A job? A better paying job? Intellectual fulfillment? 

2. How much time and money can you invest in this process?

3. What are your natural talents and academic abilities? Are you good at math or writing? Are you go with people? Can you type on a computer? Are you good with computers?

4. What is your 5-year goal? 10 years?

5. Is this your one chance to go to school or could you see yourself returning to school 5+ years down the line to get a bachelor's degree?

There is no single "right" path.  If your need a job and a relatively stable career that doesn't take very much time or money to get trained to do, then you need to look at things like LPN or dental hygienist, or something that is 2 or less years and not particularly expensive or academically taxing.

If you can afford to work part-time in retail while you pursue art, that's great, but very few people in the history of the planet are able to support themselves as artists.  Art can be a passion/interest/hobby. 

An AA in psychology or art isn't going to give you enough "skills" to get a job in those fields.  Taking those classes can be fulfilling in many ways, but they won't set you up for a job.