Tenure letters are meant to inform and persuade, and different kinds of letters are more or less helpful for persuading different kinds of people.
Your closest colleagues may not know how others in your field regard your work, and for them, a letter from an important contributor to your field will be most persuasive.
Your more distant colleagues, and your dean, may not have much idea of what you do, and for them, letters on prestigious letterheads may indicate that you and your work are widely known and well regarded.
To get tenure, you have to persuade all of these people, and so it would be good if your package contains some letters that describe your work in detail and explain why your contributions are tenure-worthy, and some letters from people who your deans will recognize as well positioned to give advice.
The chair of your tenure committee will be in charge of putting together the whole package, which can include an explanation of who the letter writers are and why they were chosen (and of what the letters say, if necessary). So...if some of your letter writers are from lesser known places, a sentence or two about the editorial boards they serve on, the prizes they have won, etc. may help their letters be as persuasive as they deserve to be to as wide an audience.