I think this question deserves an answer here in physics SE, since these notions are very common in Relativity.
For a manifold $M$ equipped with a metric (either Euclidean or Lorentzian) $g$, locally flat means that every point $p\in M$ admits an opens set $U \ni p$ endowed with coordinates $$\psi : U \ni q \mapsto (x^1(q),\ldots, x^n(q)) \in \psi(U) \subset \mathbb R^n$$
such that the metric in these coordinates takes the constant canonical form
$$g_{ab}(q) = \delta_{ab}\quad \mbox{Riemannian case}\:,$$
or
$$g_{ab}(q) = \eta_{ab}\quad \mbox{Lorentzian case}\:.$$
The point is that there is no guarantee that there is such a $U$ which covers the whole manifold. For this reason we use the adverb locally in front of flat.
An example is a two dimensional cylinder in $\mathbb R^3$ equipped with the metric induced by the standard metric on $\mathbb R^3$.
For a manifold $M$ equipped with a metric (either Euclidean or Lorentzian) $g$, globally flat means that there is a global coordinate system $$\psi : M \ni q \mapsto (x^1(q),\ldots, x^n(q)) \in \psi(M) \subset \mathbb R^n$$
such that the metric in these coordinates takes the constant canonical form
$$g_{ab}(q) = \delta_{ab}\quad \mbox{Euclidean case}\:,$$
or
$$g_{ab}(q) = \eta_{ab}\quad \mbox{Lorentzian case}\:.$$
In this case $(M,g)$ is isometrically identified with an open portion (possibly the whole space) of $\mathbb R^n$ equipped with the standard (Euclidean or Lorentzian) metric.
In view of the definitions above, the answer to your question (i) depends on the extension of your coordinate system. If it covers the whole manifold we have a globally flat manifold. If it is not the case, we can only say that a region of the manifold, the one covered by the coordinates, is flat.
Flat space and Euclidean space have more or less the same meaning. They usually indicate Minkowski spacetime (i.e. a spacetime isometrically isomorphic to $\mathbb R^n$ equipped with the standard Minkowsky metric $\eta_{ab}$) or $\mathbb R^n$ equipped with the standard Euclidean metric $\delta_{ab}$. However are a bit vague terms whose meaning (if global or local) should be understood from the context.
Regarding your last question. If all $C_i$ are positive, the metric can be recast into the standard form $\delta_{ij}$ simply rescaling (changing) the coordinates with a factor $1/\sqrt{C_i}$. If some constant is negative, with a similar procedure the metric can be reduced into a constant form $h_i \delta_{ij}$ where $h_i = \pm 1$, which is Lorentzian only if all $h_i$ are $+1$ but one (or all $h_i$ are $-1$ but one depending on the adopted convention). It is impossible that a $C_i$ vanishes because it would imply $det [g_{ij}]=0$ which is not admitted by definition of (non-degenerate) metric.
ADDENDUM. An apparently related question concerns the so called locally flat coordinates around a given point. This is an independent issue. These coordinates are also called Riemannian normal coordinates or Gaussian normal coordinates. Are coordinates $x^1,\ldots, x^n$ defined in a neighborhood of a point $p\in M$ such that exactly at $p$ the components of the metric have their canonical form (e.g. $g_{ab}(p)=\delta_{ab}$ or $g_{ab}(p)=\eta_{ab}$ depending on the nature of the metric) and $\frac{\partial g_{ab}}{\partial x^c}|_p =0$. It is possible to prove that every manifold equipped with a smooth metric admits such a coordinate system for every given point $p\in M$.
It is also possible to extend the definition referring to a geodesic $\gamma\subset M$ instead of a point $p$: Exactly on $\gamma$ the components of the metric have their canonical form (e.g. $g_{ab}(\gamma)=\delta_{ab}$ or $g_{ab}(\gamma)=\eta_{ab}$ depending on the nature of the metric) and $\frac{\partial g_{ab}}{\partial x^c}|_\gamma =0$. This form gives rise to a very precise mathematical description of Einstein's equivalence principle in GR when $\gamma$ is a timelike geodesic.
Best Answer
This is an old question but it deserves a correct answer. As it turns out, the open 2-dimensional disk admits continuum of conformally inequivalent pseudo Riemannian metrics, see
Uncountably many $C^0$ conformally distinct Lorentz surfaces and a finiteness theorem, by Robert W. Smyth, Proc. Amer. Math. Soc. 124 (1996), 1559-1566.
Edit. Furthermore, there are Lorentz metrics on the open 2-disk which do not embed conformally in the Lorentzian plane, see p. 117 of
T. Weinstein, An Introduction to Lorentz Surfaces, de Gruyter, 1996.
Last thing: In his answer Luboš Motl confused the Riemannian and pseudo Riemannian cases.