Hi... When you have two verbs like that the second is usually at the infinitive mode...

to is missing

yes you have to say " I went to visit my sister"

"I went to visit my sister." is correct but a different and shorter way of saying it is "I visited my sister."

I went to visit my sister