Answer to your question.
Let $\mathbb{Q}$ be the set of rational numbers in $\mathbb{R}$. This set is dense in $\mathbb{R}$ and it is countable. Let $q\colon\mathbb{N}\to \mathbb{Q}$ be a bijection and let $a_n$ be the $n$-th element of the sequence $0,0,1,0,1,2,0,1,2,3,0,1,2,3,4,0,1,2,3,4,5,\dots$ (you start from $0$ and add $1$, every time you reach a number that hasn't been reached before, you reset back to $0$). Then $(q_{a_n})_{n\in\mathbb{N}}$ is a sequence that has an accumulation point at each element in $\mathbb{R}$. Indeed, let $r\in\mathbb{R}$, and let $\varepsilon >0$ and $N\in\mathbb{N}$. Since $\mathbb{Q}$ is dense, there is a $p\in\mathbb{Q}$ such that $|r-p|<\varepsilon$. Let $m\in\mathbb{N}$ be such that $q_m=p$ (remember that $q\colon\mathbb{N}\to\mathbb{Q}$ is bijective) and let $n>N$ be such that $a_n=m$. Then $q_{a_n}=q_m=p$ and therefore $|r-q_{a_n}|<\varepsilon$. In conclusion, $\forall \varepsilon>0,\forall N\in\mathbb{N},\exists n>N,\; |r-q_{a_n}|<\varepsilon$ and we have that there must be a subsequence of $(q_{a_n})_{n\in\mathbb{N}}$ that converges to $r$.
But make it topological.
This property characterizes separability of topological spaces:
Proposition. Let $(X,\mathscr{T})$ be a topological space. $(X,\mathscr{T})$ is separable if and only if there exists a $\varphi\in X^\mathbb{N}$ such that for every $x\in X$, there exists a subsequence of $\varphi$ that converges to $x$.
Proof. Let $\varphi$ be one such sequence, then $\varphi(\mathbb{N})$ is countable and every element of $X$ can be approached by some sequence in $\varphi(\mathbb{N})$, that is, $X\subseteq\overline{\varphi(\mathbb{N})}$. We conclude $\overline{\varphi(\mathbb{N})}=X$ and $X$ is separable.
On the other hand, if $X$ is separable, let $Q$ be a countably dense set, biject it by $q\colon \mathbb{N}\to Q$ then $(q_{a_n})_{n\in\mathbb{N}}$ is the desired sequence ($a_n$ defined just like in the previous section) $\square$.