The wavefunctions themselves are simply the coefficients in the expansion of the quantum mechanical state vector in the position basis, as you already said:
$$\Psi(x, \ t) \ = \ \langle x | \Psi \rangle$$
I'm not sure if a Hilbert space is the right word to use, as the wavefunctions themselves are not vectors, however, any other wavefunction in our possible state space can be expressed as a linear combination of the stationary state wavefunctions of the Hamiltonian.
I'm not totally sure what you mean when you ask how the wavefunction becomes the quantum state. The point of the set of stationary state wavefunctions in the position basis is that we can write the quantum mechanical state vector as a linear combination of them.
For instance, consider the position basis $|x\rangle$. We can write some state vector as a linear combination of position eigenstates. Remember that:
$$\displaystyle\sum_{i} \ |v_i\rangle \langle v_i| \ = \ \mathbb{I}$$
For any orthonormal basis as:
$$\Big( \displaystyle\sum_{i} \ |v_i\rangle \langle v_i| \Big) |v\rangle \ = \ \displaystyle\sum_{i} v_i |v_i\rangle \ = \ |v\rangle$$
Now, this also holds for a continuous sum (an integral), so we have:
$$|\Psi\rangle \ = \ \mathbb{I} |\Psi\rangle \ = \ \displaystyle\sum |x\rangle \langle x | \Psi \rangle \text{d}x \ = \ \displaystyle\sum \Psi(x, \ t) |x\rangle \text{d}x$$
Cool, so we can expand the state vector in terms of a basis of eigenstates. But we can also expand the wavefunction in terms of another basis! For example, we can then expand the position wavefuntion in terms of the energy eigenstate basis. Thus, we have:
$$\langle x | \Psi \rangle \ = \ \langle x | \mathbb{I} | \Psi \rangle \ = \ \langle x | \Big( \displaystyle\sum_{n} \ |E_n\rangle \langle E_n | \Big) | \Psi \rangle \ \ = \ \displaystyle\sum_{n} \ \langle x |E_n\rangle \langle E_n | \Psi \rangle \ = \ \displaystyle\sum_{n} c_n \Psi_n(x, \ t)$$
So we can write the state vector as the wavefunction, and we can write the wavefunction as a linear combination of stationary states, with each of the $c_n$ coefficients corresponding to the probability amplitude of the specific energy eigenstates, thus telling us "how much" of each $\Psi_n(x, \ t)$ is in $\langle x | \Psi \rangle$.
So to answer your question, the wavefunctions are not quantum states, they are components of the quantum states that tells us certain information about the quantum state represented in a particular basis, but we can still expand/express each one as linear combinations of vector/functions in another basis.