Let $f\in\mathbb{Z}[X]$ be an irreducible polynomial. Is there an integer $a\neq 0$ such that $f(X)+a$ is also irreducible in $\mathbb{Z}[X]$?
Can this be also extended to $\mathbb{Q}[X]$?
Yes, and you don't need $f$ irreducible. The following irreducibility criterion suffices and shows that infinitely many $a$ work.
Lemma: Let $g(x) = a_n x^n + ... + a_0 \in \mathbb{Z}[x]$ be such that $a_0$ is prime and
$$|a_0| > |a_1| + ... + |a_n|.$$
Then $g(x)$ is irreducible.
Proof. The condition on the coefficients ensures that all complex roots of $g$ have absolute value greater than $1$. But if $g$ is reducible then at least one of its irreducible factors has constant term $\pm 1$, hence at least one of its roots has absolute value less than or equal to $1$; contradiction. $\Box$
Let $t$ be another variable. Then $f(X)+t$ is irreducible over $\mathbb Q(t)$. By Hilbert's Irreducibility Theorem there are infinitely many $a\in\mathbb Z$ such that $f(X)+a$ is irreducible over $\mathbb Q$. Often that is only formulated for $a\in\mathbb Q$, but the proofs which I know actually yield integers $a$.
As to irreducibility over $\mathbb Z$ versus over $\mathbb Q$, it seems to me that you should look up the Gauss Lemma.