What you're looking for is a type of what's called a "mock-up", which is basically displaying how a design or logo would look like in a real world application. This is done to give the client an idea about how their logo would look like once it gets released and applied to real objects.
The types you mention specifically are for wall mounted signs (as on the entrance of buildings and such).
You can check this answer for some tips on how to get started (although it's a different kind of mock-up, you can still learn something). You don't need anything other than photoshop to do these things.
Be aware that this is just for presentation purposes, and don't rely on it as the main logo design. You should have a working 2D vector design before you attempt to do this. So fix the basic shapes, text and colors first.
You can also google these designs now that you know the term, and study the source files (some of them you can download for free, like the one you posted), and try to understand how they were done. If there is anything specific you don't understand you can ask another question here.