All notifications within CB Activity are configured in CB Activity > Parameters > Notifications > Notify.
However the notification you're asking for doesn't exist. You'd need to create that notification yourself using CB Auto Actions. The below should help get you started.
Global
Triggers: activity_onAfterCreateStreamActivity
Type: Email
User: Self
Access: All Moderators
Conditions
Field: Custom > Value
Custom Value: [var3_asset]
Operator: Starts With
Value: profile.
Action
To: query
To Query:
Code:
SELECT `email` FROM `#__users` WHERE `block` = 0
Subject: YOUR_EMAIL_SUBJECT_HERE
Body: YOUR_EMAIL_MESSAGE_HERE
The condition ensures it only applies to profile activity posts made by moderators. If you need it to apply to other activity streams adjust the condition. If you need it to apply to all activity streams simply remove the condition. The query is just a database query to determine recipients of the email. You can freely adjust it with whatever database query conditions you'd like. My example above emails everyone.
This however could be useful and have added a feature ticket to review adding support for toggling on such a notification being built into CB Activity as could be good for things like moderator announcements.
forge.joomlapolis.com/issues/9681
forge.joomlapolis.com/issues/9682
Also made a ticket for system post notifications.