You cannot play as Cyndaquil, but you can select it as your partner at the start of a new game:
Your player character is a separate Pokémon (chosen via personality quiz), but Cyndaquil will accompany you throughout the adventure.