Beyond the basics of just using Photoshop, or any modern painting program, in which it is not that hard to achieve the effects you are looking for by using layers, the rest is down to tweaking the image and effects to get exactly what you think looks good. There is no magic bullet.