Ask and ye shall receive.

My best advice to finding a good artist is to ask around. If you see someone with tattoos you like, or at least an artist's style you like, ask them what shop they went to and who did the work. Talk with artists and get a feel for their personality. You want someone who will draw up what you want and take the time to do it right, not what is quick and easy for them. Look through the portfolios artists put out. I know some very good artists, but their style isn't for me. The shop should be clean: gloves when tattooing with a change if they take a break to drink, smoke, go to the bathroom, answer the phone, etc.; new needles for each customer; putting the ink in little disposable cups or trays instead of sticking the needle in the big bottle. Most shops seem to be pretty good about hygiene, the fear of AIDS and other diseases has led to a big focus on health in the tattoo industry.
Depending on how much work you get done, you may need to break up your design into sessions. I did the koi in one sitting, but am putting off the background for about a month. They are not maintenance free, especially at first. You need to constantly put lotion on them for a couple of weeks (I use Neosporin creme for the first two or three days then fragrance-free Lubriderm for two weeks). If you don't use sunblock now, you need to afterwards or they will fade. Alcohol beforehand might seem like a good idea to help dull the pain but it will make you bleed excessively and the won't let the ink set properly and you will have to get it redone. Alcohol afterwards is always a good thing.
As far as pain it ranges from mild annoyance to fairly sharp pain depending on the sensitivity of the area of the body. As soon as the needle is removed the pain stops. You can always ask the artist to take a break if you need one. There isn't really any pain afterwards. To me it feels like a mild sunburn for a few days. Wear loose fitting clothes that you don't care if you need to throw out as you will bleed.
If you happen to be in Las Vegas or Phoenix I can direct you to some shops. If you have any more questions feel free to ask.