It's unusual that I have to ask for a definition on this site, but it in the context of spin structures, it seems common to talk about double covers without giving the definition. I understand the definition of a covering space, but the definition of double covers (more generally, $n$-fold covers) on Wikipedia is based on an alternative definiton of covering spaces I don't understand:
Equivalently, a covering space of $X$ may be defined as a fiber bundle $p\colon C\to X$ with discrete fibers.
And further below:
A covering is a double cover if every fiber has two elements.
I don't know what they mean by "discrete fibers". The article links to the discrete topology of a set, but I don't see the correlation. In the case of a double cover, does it simply mean that each fiber $p^{-1}(\{x\})$ consists of two elements for all $x\in X$?
Your first bullet point: To repeat the definition you most likely already know, for any function $p : A \to B$, a "fiber" of $p$ is a certain kind of subset of $A$, namely one which can be written in the form $p^{-1}(\{b\})$ where $b \in B$.
Assuming now that $A$ and $B$ are topological spaces, each fiber, being a subset of $A$, inherits the subspace topology relative to $A$
So, to say that a continuous map of topological spaces $p : A \to B$ has "discrete fibers" means that each fiber is a discrete topological space with respect to the subspace topology relative to $A$.
Your second bullet point (regarding older version of post): I'm not sure why you are concerned with whether a two point set is a union open sets. Nothing in the definitions requires a fiber $p^{-1}(x)$ of a covering map $p : C \to X$ to be a union of open set; in fact that is practically never the case.
Perhaps you are misreading the definition? You have only partially typed out the relevant part of the definition, leaving (...) for the part which explains this issue in full. Suffice it to say that in that portion, the definition is not referring to $p^{-1}(\{x\})$ being a union of open sets for a point $x \in X$. Instead, it is referring to $p^{-1}(U)$ being a union of open subsets of $C$, where $U$ is itself an open subset of $X$.
Perhaps one thing that might help is to learn the following theorem/definition (which you ought to be able to find in most textbooks where covering maps are defined, such as James Munkres' Topology):
Once that theorem is proved, another definition of a double covering map is a covering map of degree $2$.
Perhaps another thing that might help is to see some familiar examples of double covering spaces: