Let the sides be $n-1$, $n$, and $n+1$ for $n \in \Bbb{Z}$ with $n > 0$. (You don't explicitly reject degenerate triangles with $n - 1 = 0$...)
By Heron's formula, the area is
$$ A = \sqrt{s(s-(n-1))(s-n)(s-(n+1))} \text{,} $$
where $s = (1/2)((n-1) + n + (n+1)) = (3n/2)$, so
\begin{align*}
A &= \sqrt{s(s-(n-1))(s-n)(s-(n+1))} \\
&= \sqrt{(3n/2)((3n/2)-n+1)((3n/2)-n)((3n/2)-n-1)} \\
&= \sqrt{(3n/2)((n/2)+1)(n/2)((n/2)-1)} \\
&= \sqrt{\frac{3}{16}n^2(n^2 - 4)} \\
\end{align*}
By plugging in $0$, $1$, and $2$, we quickly see that $3 \mid n^2(n^2 - 4)$. With a similar computation, we find $n^2(n^2 - 4)$ is divisible by $16$ exactly when $n$ is even, so $n = 2m$.
$$ A = 3\sqrt{\frac{4m^2(4m^2 - 4)}{3 \cdot 16}} = 3\sqrt{\frac{m^2(m^2 - 1)}{3}} $$
By plugging in $0$, $1$, and $2$, we quickly see that $3 \mid m^2(m^2 - 1)$, so $\frac{m^2(m^2 - 1)}{3}$ is an integer for any choice of $m$.
So we want to solve
$$ \frac{m^2(m^2 - 1)}{3} = u^2 $$
in integers. That is,
$$ (m^2)^2 - 3u^2 = m^2 \text{.} $$
Notice $m^2$ divides two terms, so it divides all three. Divide through by $m^2$, obtaining
$$ m^2 - 3(u/m)^2 = 1 \text{,} $$
a Pell's equation, where we seek solutions in the integers $m > 0$ and $u/m \geq 0$.
By the usual application of continued fractions, we obtain a general solution. We don't actually need the form of $u/m$, but,
$$ m = \frac{1}{2} \left( (2-\sqrt{3})^c + (2+\sqrt{3})^c \right) $$
for integer $c \geq 1$. Then suitable triangles are obtained from all
$$ n = \left( (2-\sqrt{3})^c + (2+\sqrt{3})^c \right) $$
for integer $c \geq 1$. (This includes the degenerate $1$-$2$-$3$ triangle when $c = 0$.)