Implement destroy service for v2 approval rules
<!--IssueSummary start-->
<details>
<summary>
Everyone can contribute. [Help move this issue forward](https://handbook.gitlab.com/handbook/marketing/developer-relations/contributor-success/community-contributors-workflows/#contributor-links) while earning points, leveling up and collecting rewards.
</summary>
- [Close this issue](https://contributors.gitlab.com/manage-issue?action=close&projectId=278964&issueIid=587135)
</details>
<!--IssueSummary end-->
Implement destroy service for v2 approval rules.
Requirements:
- Check authorization
- Find the approval rule by ID
- Validate rule can be deleted (only MR-level rules with `origin: :merge_request`)
- Destroy the rule (cascade deletes join table records and approver associations)
- Return ServiceResponse with success/error
Reference: POC implementation in `poc/v2-approval-rules-complete` branch
issue