A tattoo that "sits in the skin" shouldn't be a layer that paints over the skin. Try the "multiply" function - means, mulitply the layer with the original skin. That helps and keeps the skin structure better than just transparency.

In the sample I wanted bright, crisp colour on the shoulder, while the dragons should have been paler, "older".
You can have pretty much what you want with that "multiply" thing.

www.skin2pix.com