From what little I know (from looking in on a long ago archived game), units without their upkeep resource seem to slowly lose morale until they apparently die.
Buildings without their upkeep resource will become increasingly damaged (though I don't know if any disappear).
