If it is a personal story, a mix of past, present, and future tenses are used.
Ex: My father died last Monday and his funeral is tomorrow. He was a wonderful man who we will miss. (note - whom we will miss is archaic and rarely used now)
If it is a retelling of a joke, a fable, a book, or a movie, the simple present tense is normally used ("narrative present tense").
Ex: A man and a dog walk into a bar. The man orders a beer. Then, the dog orders a beer. Surprised, the bartender says to the man, "your dog talks!" The man says....