Set up Bitbucket Pipeline for Acquia deployment

[mrdavidburns]

depends on: #454

Using the task commands set up in #454 let's add a composer.json Drainpipe configuration that will scaffold a Bitbucket Pipeline for deploying to Acquia. Let's have it so that this happens anytime something gets merged into main branch.

This would match functionality that we do with PantheonReviewApps

[mrdavidburns]

As discussed during Drainpipe sync (11/4/24) let's hold off on having Drainpipe do the scaffolding for Bitbucket Pipelines. Let's build those directly on the projects that need this functionality and once we have 3 or more clients that need this functionality we'll have working examples to reference to help standardize this into Drainpipe.

Unassigning for now and setting to Blocked for reason stated above.