I want to add bullet holes to an existing pistol fire script that I have created. I am not sure if it can even be added. Any suggestions are helpful.

ValGreenEs17 said:
pistol fire script

From that i assume you use an engine like Unity or UE? You should mention such details to receive proper help ; )

Lookup the decals system of your engine. It should work to splat damage using a bullet hole texture to the geometry of the level.
If you want a true hole where you can look through walls, that's much harder and costly. Maybe the destruction system could handle this for big holes like from explosions, but for small holes that's surely overkill and you want to use decals.