To answer your first question,
In the Langevin model, if we make the assumption that the random force
η(t) acting on the Brownian particle is a stationary, Markovian, and
gaussian process, does it automatically ensure that the autocorrelator
$⟨η(t_1)η(t_2)⟩∝δ(t_1−t_2)$?
No. The most general form of Langevin equation is given with coloured noise (which is NOT delta correlated). I will show how the Langevin equation pans out in the case of white noise (i.e. delta-correlated).
As I show below, the random force (or noise) acting on the particle need not be delta-correlated to be Markovian. For example, a stationary Gaussian distributed coloured noise with an exponential autocorrelation, $⟨η(t_1)η(t_2)⟩∝\exp(\frac{t_1 - t_2}{\tau})$, is Markovian.
Secondly, I completely agree with the answer of Roger Vadim, but I have a perspective which might be helpful in understanding why the following statement is usually made (as asked in your question),
The reason I am asking this is that deviation from delta-correlated autocorrelator is often regarded as a signature of non-Markovianity.
I think the signature implies that if the driving noise, $f(t)$ is coloured (NOT delta-correlated), then the driven process, $x(t)$, will essentially become non-Markovian.
I will try to illustrate this behaviour with an example of the Langevin equation.
In general, the Langevin-like Stochastic differential equations (SDEs) is given by (also called by generalised Langevin equation),
$$
\frac{dx}{dt} = -\int_{0}^{t}\mu(t-t')x(t')dt' + f(t)
$$
where I will refer to $x(t)$ as the driven process and $f(t)$ as the driving noise. Here, $\mu(t)$ is a memory kernel. Although the noise and memory kernel in this equation look independent, they have to be related to each other by a fluctuation-dissipation relationship given by,
$$
\left<f(t)f(t')\right> = \Gamma\mu(t-t')
$$
where $\Gamma$ is a constant to match the appropriate dimensional scaling.
Case of white noise
In this scenario, the driving noise $f(t)$ is delta correlated (let's say with a variance $\Gamma$), therefore the autocorrelation is given by,
$$
\left<f(t)f(t')\right> = \Gamma\delta(t-t')
$$
Using this in the first and second equations, the Generalised Langevin equation simply reduces the usual Langevin equation
$$
\frac{dx}{dt} = -\Gamma x(t) + f(t)
$$
The solution for this equation can be shown to be essentially Markovian, i.e. the driven process $x(t)$ is Markovian in nature if the driving noise $f(t)$ is White.
Case of coloured noise
A coloured noise is essentially a stochastic process with some finite correlation time (in the case of delta-correlated process, this is implicitly zero). Let's consider a stationary coloured noise with an arbitrary correlation function, such that,
$$
\left<f(t)f(t')\right> = \Gamma \lambda(t-t';\tau)
$$
where $\tau$ is the characteristic timescale associated with the decay of the coloured noise autocorrelation. Therefore in the case of coloured noise, the process $f(t)$ can be both Markovian or non-Markovian. A typical example of Markovian coloured noise can be defined through an exponential autocorrelation, $\lambda(t) = \exp(-t/\tau)$
But irrespective of the Markovianity of $f(t)$, if $f(t)$ is coloured, one can directly verify from the first two equations, that the driven process $x(t)$ becomes non-Markovian.
In summary
- If the driving noise, $f(t)$, is delta correlated, then the driven process, $x(t)$ is essentially Markovian.
- If the driving noise, $f(t)$, is NOT delta correlated (i.e. coloured noise), then the driven process $x(t)$ is non-Markovian.
I think it is in this context, signature of non-Markovianity is regarded through a deviation from delta-correlated autocorrelator.