All the standard ones are in the GCF file, which can be opened with GCFScape. If you want more, you could make your own, or find them on a site like The Wadfather. DoD textures are just like any other Half-Life texture, so you don't have to worry about compatibility, or anything like that.