Add Watcher task for Execution Mode Watcher to monitor models status

[pankajastro]

Implement a sensor to monitor the status of DBT models triggered via the dbt build command on the root dbt build task/node in a DAG. This will allow workflows to wait for DBT execution to complete and respond accordingly.

Related Issues

• Introduce ExecutionMode.WATCHER #1964
• [Feature] Introduce a new execution mode with a dbt runner task and subsequent watcher tasks #1950

Proof of Concept

• https://github.com/astronomer/astronomer-cosmos/compare/single-run-execution-mode?expand=1

Acceptance Criteria:

• Implementation for the sensor
• Unit tests covering the change