Creating Areas of transparency

How can I create ‘holes’ in meshes by creating areas were it skips rendering it? sort of like a bullet hole but you can actual see through the hole without modifying the mesh.

Maybe you can make different maps that switch when hit in a specific place- like have different pngs with holes that scripts to change when hit in an area (like with trigger boxes)?