[guided]We want coordinates in which the constraint equations become as simple as possible. The regularity hypothesis gives exactly the linear algebra needed for this.
Fix $q \in C$. Since $0$ is a regular value of $F$, the differential
\begin{align*}
dF_q: T_qQ \to T_0\mathbb{R}^k \cong \mathbb{R}^k
\end{align*}
is surjective. Choose a smooth chart $(U,\varphi)$ around $q$, with
\begin{align*}
\varphi: U \to \varphi(U) \subset \mathbb{R}^n.
\end{align*}
In this chart define
\begin{align*}
f: \varphi(U) \to \mathbb{R}^k, \quad f := F \circ \varphi^{-1}.
\end{align*}
The differential of $f$ at $\varphi(q)$ represents $dF_q$ in coordinates, so its Jacobian matrix $Jf_{\varphi(q)}$ has rank $k$. Therefore some $k$ coordinate directions give an invertible $k \times k$ minor. Reordering coordinates if needed, assume this invertible minor uses the variables $x_{n-k+1},\dots,x_n$.
Now define
\begin{align*}
G: \varphi(U) \to \mathbb{R}^n, \quad G(x_1,\dots,x_n) := (x_1,\dots,x_{n-k}, f_1(x),\dots,f_k(x)).
\end{align*}
The point of this definition is that the first $n-k$ coordinates are left unchanged, while the last $k$ coordinates are replaced by the constraint functions. The Jacobian matrix $JG_{\varphi(q)}$ has an invertible lower-right $k \times k$ block, and the first $n-k$ output coordinates depend on the first $n-k$ input coordinates as the identity. Hence $JG_{\varphi(q)}$ is invertible.
By the finite-dimensional inverse function theorem, after shrinking $U$ to a smaller open neighbourhood of $q$, the map $G$ is a diffeomorphism from $\varphi(U)$ onto an open subset $V \subset \mathbb{R}^n$. Define the adapted coordinate chart
\begin{align*}
\psi: U \to V, \quad \psi := G \circ \varphi.
\end{align*}
In these new coordinates $y = (y_1,\dots,y_n)$, the last $k$ coordinates are precisely the components of $F$. Thus
\begin{align*}
F \circ \psi^{-1}(y) = (y_{n-k+1},\dots,y_n).
\end{align*}
This is the local normal form for a submersion: near a constrained point, the constraint map is projection onto the last $k$ coordinates.[/guided]