Overpainting tutorial

I think that it depends on the style that you would like to paint in.  My idea would be to use a photograph of a street as a template.  Lower the opacity and then paint over it in other layers.  Depending on how detailed you want to get... you may need to use several layers.  Make sure to name your layers so you know what you painted where, it is always good to be organized.

I would imagine you will find various tutorials on YouTube: digital painting, environmental painting, cityscape painting, etc.  Those are some terms to look up. 

Do you have a favorite painter? Style? Or what will the image be used for?

Hi

Perhaps you could provide a more detailed description of what you want to achieve and a sample image would help and most of all which Adobe application are you referring to, I would assume it's Photoshop