I'm assuming this is for Warcraft 3, otherwise everything below doesn't apply. You can animate the alpha of a model's materials or you create add geoset animations to toggle visibility on and off in Magos Model Editor. The problem with geoset animations is that the model is either 100% transparent or 100% opaque. With animated alpha you can have it fade from 0-100% transparency. This is likely what you want. The problem with this is that any materials that use team colour will not show transparency properly. Alternatively, you can use triggers to make a unit fade in and out.