College Station city manager announces resignation