Instead of having 3D models or anything for ET and the baddies, I want to have flat 2D sprites like this:

I know how to load textures, but I don't know how to set a certain area to transparent. Do I need to figure out how to check each pixel on a texture and replace, say, (1.0, 0.0, 1.0) with ... nothingness. 0.o;
I don't know. I assume there's a function in OpenGL to turn an image partially or fully transparent, and I just need to do that for the appropriate pixels.