Transparent GIFs and PNGs can be used on objects and walls.
Remember that a wall has two sides, so you need to apply two (different?) transparent textures to make a wall transparent.
I've never tried it, but floors and ceilings should also become transparent with transparent textures.
Note that transparency is only correctly shown when you make a photo or video of quality level 3 or 4.