Explore and add static checks for DAGs for early detection of common issues

### Description As per users' feedback in the Airflow Debugging Survey 2024, 48.3% of respondents chose early issue detection during execution as one of their top 2 choices. ### Use case/motivation Goal of this issue: - Enhance early detection of DAG issues to minimize dev time - Some sort of static analysis similar to Ruff checks for DAGs - Runtime analysis of DAGs if feasible can also be done to save dev time ### Related issues Parent Issue: https://github.com/apache/airflow/issues/40975 ### Are you willing to submit a PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [x] I agree to follow this project's [Code of Conduct](https://github.com/apache/airflow/blob/main/CODE_OF_CONDUCT.md)