The first thing you need to do is your homework. You need to investigate your local tattoo parlors and meet with various tattoo artists. Take a look a their portfolio and see if their tattoo drawings are in line with your vision. Explain to them your ideas and ask them to come up with a design on paper. This way you can lay out the concepts from several artists and decide which is the best.
Speaking of tattoo drawings if you want ideas you have a ton of access with the advent of the internet and Google. You can search and find any tattoo design imaginable. If you want your own you can take several tattoo designs and combine the aspects you like of each into your own. That's why its a good idea to work with prospective artists to have them come up with a design around your image.
Tattoos hurt there is no getting around this and some might be inclined to get into the chair after having a few doses of "liquid courage" but this is a bad idea. Alcohol thins the blood and will make the process messy for the artist. The end result will most likely be something that doesn't look like what you imagined. So its best just to grin and bear it as the pain will only be temporary and will subside.
Finally, another important consideration is are for your tattoo drawing. You will most likely leave with a bandage over your tattoo and its important to keep this on. The bandage will protect the area from bacteria which could cause an infection and ruin the work. Sometimes tattoo artists cover the tattoo with saran wrap. This isn't always the best option as it doesn't allow the area to breath and this won't aid the healing process. You will want to wash the tattoo with warm water and and antibacterial soap. After cleaning use an anti-bacterial ointment to help the area heal but don't use Neosporin as some may have an allergic reaction with the end result being the loss of ink in areas of the tattoo making it look blotchy.
If you follow these steps you should end up with a great tattoo representative of yourself and your personality. If you are like many others this won't be your last tattoo drawing either as many get the tattoo bug after the first!