Usually you use the matte painting as the base, and then add footage elements to give it more life (if needed). The matte painting itself can be made out of any type of element.
Take a look at our gallery
to see how matte painting has been used in other productions.
And if you have a production in hand and looking for a solution for a specific shot, post it here and Iím sure people in this forum will help you.