The visitor visa and the Super Visa are temporary authorizations: they let you stay in Canada, but they do not give permanent residence.
Visiting Canada
The visitor visa suits family visits, tourism and certain business activities. The Super Visa is for the parents and grandparents of a Canadian citizen or permanent resident.
Extending your stay
If you are already in Canada and want to stay longer, an extension is a separate process from the visa application.