Though it is very much country specific but here is some basic difference -
If a person is on Tourist Visa, he/she may have to exit the country after the possible stay of 30/90 days (depends on country)
Visiting Visa is also issued for 30/90 Day’s but the good thing is the person doesn’t have to Exit the country and the Visa can be converted into employment or residence visa within the country.