Add just makes dark colours transparent and bright colours glow, which means it's only any good for things like Muzzle flashes or light beams. You wanna put an Alpha Mask on your texture and use Alpha Blend mode.
Making an Alpha Mask on your texture will be explained in the help section on whatever image editor program you use, it's not too difficalt once you know
