Add new Design brief issue template

What does this MR do and why?

Adds a new Design brief issue template.

👉 See test issue

Related content:

• Issue: [DRAFT] DORFD Design Issue Template Redesign (#454710 - closed)
• Slack thread: https://gitlab.slack.com/archives/C028Q5SUXC4/p1724340075044469

%{first_multiline_commit}

MR acceptance checklist

Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.