Your texture goes into the models_units/textures/ folder.

You then tell the game to find that texture by looking in the descr_model_battle.txt and changing the texture entry for a particular unit and faction.