Um. You want all pixels that are painted one particular color in your texture to be transparent? I guess you could write a shader to do that. But there’s no way to do it using the standard fixed-function pipeline.
It would be easiest to edit the texture in a program like Gimp or Photoshop and put an alpha channel on. Then set the alpha channel to 0 wherever you want it to be transparent.
David