I think what follows gives an "arithmetic" example of what you're looking for: a variety $X$ over a number field $k$ such that $X$ is $\mathbb{Q}$-factorial but $X_L = X \times_k L$ is not, for some finite extension $L/k$. In other words, $X$ is $\mathbb{Q}$-factorial, but not locally $\mathbb{Q}$-factorial in the étale topology. Take an elliptic curve $E$ over $k$ which has rank zero over $k$, but positive rank over $L$. Let $X$ be the projective cone over $E$. Then the only Cartier divisors on $X$ are multiples of a plane section. The fact that $E(k)$ has rank zero shows that every divisor on $X$ over $k$ has a multiple which is Cartier. On the other hand, let $P$ be a point of infinite order on $E(L)$; then the line over $E$ gives a Weil divisor on $X_L$ no multiple of which is Cartier. I imagine the same argument, starting from a elliptic surface over $\mathbb{P}^1_\mathbb{C}$, could give a "geometric" example. I've got to go and teach now, but will try to fill in the details later.