Add `activate()` and `deactivate()` span API

[sentrivana]

Right now, starting and finishing a span without the context manager is clunky, having to call __enter__() and __exit__(). We should consider porting activate() and deactivate() from potel-base.

Reference PR from potel-base: #4447

[linear]

PY-1890