For OpenXcom, the pixels that you paint with color index 0 will be transparent.
The GIF or PNG file can have any color tagged as transparent, or none, it will make no difference.
Which program to use ? Any that gives you control on color numbers. (Photoshop is not one of them)