To show the desired (weak) consistency, you have to show that $\frac{1}{n}\sum_{i=1}^n (X_i - \mu)^2$ converges in probability to $\sigma^2$ as $n$ tends to infinity.
To that end, note that
$$
\frac{1}{n}\sum_{i=1}^n (X_i - \mu)^2
= \frac{1}{n} \sum_{i=1}^n X_i^2
- 2 \cdot \mu \cdot \frac{1}{n} \sum_{i=1}^n X_i
+ \mu^2.
$$
Assuming $X_i \overset{\mathrm{i.i.d.}}{\sim} \mathcal N(\mu, \sigma^2)$ for $i \in \{1, \ldots, n\}$, the weak law of large numbers gives
$$
\frac{1}{n} \sum_{i=1}^n X_i \overset{p}{\underset{n \to \infty}\longrightarrow} \mathbb E[X_1]\;\; \text{and} \,\;
\frac{1}{n} \sum_{i=1}^n X_i^2 \overset{p}{\underset{n \to \infty}\longrightarrow} \mathbb E[X_1^2].
$$
With $\mathbb E[X_1] = \mu$, the continuous mapping theorem yields
$$
\frac{1}{n} \sum_{i=1}^n X_i^2
- 2 \cdot \mu \cdot \frac{1}{n} \sum_{i=1}^n X_i
+ \mu^2 \overset{p}{\underset{n \to \infty}\longrightarrow}
\mathbb E[X_1^2] - 2 \cdot (\mathbb E[X_1])^2 + (\mathbb E[X_1])^2.
$$
Finally, $\mathbb E[X_1^2] - 2 \cdot (\mathbb E[X_1])^2 + (\mathbb E[X_1])^2 = \mathbb E[X_1^2] - (\mathbb E[X_1])^2 = \mathbb V[X_1] = \sigma^2.$
Strong consistency follows analogously by using the strong law of large numbers and replacing convergence in probability by almost sure convergence.