Add PubSub queue impl to e2e tests

### Problem Statement

Currently only Redis is being tested as a Queue implementation in the e2e tests

### Proposed Solution

Use GCP PubSub emulator for testing as well

### Alternatives Considered

_No response_

### Willingness to Contribute

Yes, I can submit a PR

### Additional Context

_No response_