Restrictions placed on travel and indoor gatherings in Aberdeen are to be lifted from midnight, the Scottish Government has confirmed.