[CMAKE] Move the upgrade activated tests out of the TestSuite module

Summary:
The TestSuite module is shared code and should not contain project
dependent behavior; e.g. it makes no sense to have this code be part of
the secp256k1 library.

There is no change in behavior.

Depends on D5312.

Test Plan:

ninja check check-upgrade-activated

Reviewers: #bitcoin_abc, jasonbcox

Reviewed By: #bitcoin_abc, jasonbcox

Differential Revision: https://reviews.bitcoinabc.org/D5313