Add tooltips around Domain Type to explain Domains

[Ashish8689]

Issue from #13316 (comment)

• Needed some info/description around different domain types on UI

Screenshots or steps to reproduce

Version:

• OS: [e.g. iOS]
• Python version:
• OpenMetadata version: [e.g. 0.8]
• OpenMetadata Ingestion package version: [e.g. openmetadata-ingestion[docker]==XYZ]

Additional context
Add any other context about the problem here.

[sureshms]

@Ashish8689 Here is some reference for domain types - https://www.datamesh-architecture.com/#mesh

Descriptions should be:
Source-aligned
Domains closer to online services and transactional databases that include events, and transactional data.

Aggregate
Domains that collect and curate the data from multiple source-aligned to provide aggregated data and data products, such as Customer 360, Customers sessions, etc., for other domains to consume.

Consumer-aligned
Domains that are user-facing where the end product of a combination of data from various domains are available for business users or data citizens for data-driven decision-making.