Custom textures for "Golden" or "Legendary" units are added to the game files.
Sophisticated mods often require you to manually place an OBB (Data) file in your system folder; if a site provides clear instructions for this, they are usually more legitimate.