Past and Present tense: which, why, when and how

It's a simple, but huge, decision you have to make about your novel or creative non-fiction, right at the beginning: will your main narrative tense be past tense, or present tense? And what, if anything, will you use the other one for? It is always possible to change your mind...