tourist visa - you are the one who apply for it through the hotel in Doha; it is valid 1 month, probably is extendable for another month, but not sure about it.
visit visa - one of your family members who has a permanent residence in doha and meets certain requirements, applies for this visa for you. This person becomes your sponsor for the time of your visit (up to 6 months).