It's really hard to find for sale now, but you can possibly find it for free on an abandoned-games website.

For mods, I highly recommend:
*XCOM Enemy Unknown CE: fixes lots of bugs
*MP3 Music Patch: Imports the music from the Playstation I version (much better than the original PC music).
*D3DWindower: This is a great utility that can run lost of old dos games in a window on your desktop.
*Alien Voice Patch: Restores the original, scarier alien scream sound.
Get the mods/utilities here.
Overall, if you haven't played this game, you are really missing out.