In this tutorial you can learn how to post process a 3D render in Photoshop. Keep in mind that you will need a lot of stock images to make this kind of artworks. It’s useful to know that you will make your work easier in Photoshop if you add as many details as you can in the 3D software, even if image is in low resolution.
Google SketchUp is probably the most popular 3D software. It is applicable in many fields, and thus in architecture, particularly for the fast creation of model variations. In this project-based training led by instructor Dan Brown you can learn how to create a building model (exterior and interior).
Revit Architecture, along with ArchiCAD, is most used BIM software in architectural design. Although book is not the best medium for learning computer software, there are some useful handbooks if you often use this software. Refers to the latest version of Revit Architecture, 2014.