No, you do not need to be physically present at the ADA or stockbroking company to reactivate your CDS account.
You may reactivate your dormant CDS account via the Bursa Anywhere app or call your broker. Reactivation of a dormant account will require a fee.