Here's an elementary solution using characteristic functions. Let $\phi_0$ denote the characteristic function of the distribution $\mathcal N(0,1)$.
For $n\geq 1$, let $Y_n = \frac 1{\sqrt n} (X_1X_2+\ldots+X_n X_{n+1})$ and note that
$$
\begin{align}
\forall n\geq 3, \forall t\in \mathbb R, \; \phi_{Y_n}(t)&= \phi_{Y_{n-2}}\Big(t \sqrt{\frac{n-2}n}\Big) E\Big[E\big[\exp(i\frac{t}{\sqrt n})X_n(X_{n-1}+X_{n-2})\big|X_n\big]\Big]
\\
&= \phi_{Y_{n-2}}\Big(t \sqrt{\frac{n-2}n}\Big) E\Big[\phi_0\big(\frac{t\sqrt 2X_n}{\sqrt n}\big)\Big] \\
&= \phi_{Y_{n-2}}\Big(t \sqrt{\frac{n-2}n}\Big)\Big( 1+\frac{2t^2}n\Big)^{-1/2}.
\end{align}
$$
Iterating, for $n\geq 3$ and $k\leq (n-1)/2$,
$$\forall t\in \mathbb R,\; \phi_{Y_n}(t) = \phi_{Y_{n-2k}}\Big(t \sqrt{\frac{n-2k}n}\Big)\Big( 1+\frac{2t^2}n\Big)^{-k/2}.$$
Besides, similar conditioning shows that $\forall t\in \mathbb R$, $\phi_{Y_2}(t) = \phi_{Y_1}(t) = (1+t^2)^{-1/2}$, thus
$$\begin{align}
\forall n\geq 2, \forall t\in \mathbb R,\;
\phi_{Y_{2n}}(t) &=
\phi_{Y_{2n-2(n-1)}}\Big(t \sqrt{\frac{2n-2(n-1)}{2n}}\Big)\Big( 1+\frac{2t^2}{2n}\Big)^{-(n-1)/2} \\
&=\Big(1+\frac{t^2}n\Big)^{-1/2}\Big( 1+\frac{t^2}{n}\Big)^{-(n-1)/2} \\
&=\Big( 1+\frac{t^2}{n}\Big)^{-n/2}
\\&\xrightarrow[n\to \infty]{} \exp\Big(-\frac {t^2}2\Big)
\end{align}$$
and similarly
$$
\phi_{Y_{2n+1}}(t) = \Big(1+\frac{t^2}{2n+1}\Big)^{-1/2}\Big( 1+\frac{2t^2}{2n+1}\Big)^{-n/2} \xrightarrow[n\to \infty]{} \exp\Big(-\frac {t^2}2\Big).
$$
By Levy's theorem, $Y_n$ converges in distribution to $\mathcal N(0,1)$.