How can we use the Contains operator for the Accounts field while searching activities?

Use Workspace or Sales in the Redwood user experience for your searches. These newer interfaces, which use Adaptive Search, already include the Contains operator.