If the space $(X,\mathscr{B},\mu)$ is $\sigma$--finite the notion of locally null and null sets as well as the essential suprema and local essential suprema coincide:
For a given numerical measurable function $f$ with $\mu(|f|=\infty)=0$, define
\begin{aligned}
B_e&:=\{M>0: \mu(|f|>M)=0\}\\
B_\ell&:=\{M>0:\mu(A\cap\{|f|>M\})=0,\,\forall A\in\mathcal{L}_1\}
\end{aligned}
Since $B_e\subset B_\ell$,
$$\|f\|^\ell_\infty=\inf B_l\leq \inf B_e=:\|f\|^e_\infty$$
Hence, the essential supremum of $f$ is at least as large as the local essential supremum. It is easily checked that $\mu(|f|>\|f\|^e_\infty)= 0$, and $\mu(A\cap\{ |f|>\|f\|^\ell_\infty\})=0$ for any integrable set $A$.
In the case where $X=\bigcup_{\in\mathbb{N}}A_n$, $A_n\in\mathcal{L}_1$,
$$
0=\sum_n\mu(A_n\cap\{|f|>\|f\|^\ell_\infty\})=\mu(|f|>\|f\|^\ell_\infty)
$$
and so, $\|f\|^e_\infty\leq \|f\|^l_\infty\leq \|f\|^e_l$. This shows that for $\sigma$--finite spaces there is no need to worry about locally null sets for they are the same as null sets and nothing is gained by introducing the former.
One of the main reasons one deals with locally null sets when $\mu$ is not $\sigma$-finite is to guarantee that a version of Riesz Representation concerning the dual space of $(L_1)^*$, namely the linear map $T:L_\infty\rightarrow L^*_1$ is an isometry. A couple of things may go wrong if $(X,\mathscr{B},\mu)$ is not $\sigma$-finite space.
Depending on which pseudonorm is used ($\|\;\|^\ell_\infty$ or $\|\;\|^e_\infty$) the definition of $L_\infty$ may exhibit quite different properties.
Choosing $\|\;\|^\ell_\infty$ is better for duality. Even so, $T$ may failed to be onto.
Example 1: Consider a non empty set $X$ equipped with the trivial $\{\emptyset,X\}$ and the measure $\mu(X)=\infty$, $\mu(\emptyset)=0$.
Then, the space $\mathcal{L}_0$ of all measurable functions coincides with the the space of all constant functions; a function $f$ is $\mu$-a.s 0 iff $f$ is the constant function $0$ and so, $\mathcal{L}_0=L_0$. For any $0<p<\infty$, $\mathcal{L}_p=\{\mathbf{0}\}$. The identification $\sim_p$ of functions $f,g$ such that $\|f-g\|_p=0$ gives $\mathcal{L}_p=L_p$ for all $0<p<\infty$. If $f\equiv c$, $\|f\|^\ell_\infty=0\leq |c|=\|f\|^e_\infty$. Hence $\mathcal{L}_\infty=\mathcal{L}_0$. The identification $\sim^\ell_{\infty}$ using $\|\;\|^\ell_\infty$ gives $L_\infty=\{\mathbf{0}\}$ while the corresponding $\sim^e_\infty$ using $\|\;\|^e_\infty$ gives $L_\infty=\mathcal{L}_\infty=\mathcal{L}_0$. This example shows, at least for duality purposes, why it is convenient to use $\|\;\|^\ell_\infty$.
Example 2: Cohn's measure theory textbook (p. 140, example 4.5.2) shows an example where $T$ is not surjective.
$L_p$ spaces ($1< p<\infty$) are not impacted, that because the Riesz representation ($L^*_p$ and $L_q$ are isometric, $\frac1p+\frac1q=1$) holds whether $\mu$ is $\sigma$-finite or not. For $p=1$ and $\mu$ non $\sigma$-finite, the isometry $L^*_1$ and $L_\infty$ holds when the space $(X,\mathscr{F},\mu)$ has additional structure ($\mu$ is decomposable: There is a partition $\{X_\alpha\}\subset\mathscr{B}$ of $X$ such that (1) $\mu(X_\alpha)<\infty$ for all $\alpha$, (2) for any $E\subset X$, $E\cap X_\alpha\in\mathscr{B}$ implies that $E\in\mathscr{B}$, and (3) for any $E\in\mathscr{B}$, $\mu(E)=\sum_\alpha\mu(E\cap X_\alpha)$ ).
Two other aspects of integration theory which are impacted outside the realm of duality for non-$\sigma$-finite spaces are (a) product of spaces (there may not be a Fubini-Tonelli type theorem) and (b) Radon--Nykodim derivative (there may not be one).