Create a Realistic Photo Composite From a Sketch

What You’ll Be Creating This tutorial was originally published in December 2012 as a Tuts+ Premium tutorial. It is now available free to view. Although this tutorial does not use the latest version of Adobe Photoshop, its techniques and process are still relevant

More here:
Create a Realistic Photo Composite From a Sketch