There are so many facets to changing how a paper presents its content, it would be impossible to discuss here in brief.
In short, a redesign is not as cut and dry as just looking at other newspapers for ideas. You have to determine what you want to accomplish from a content level first. If you're just aiming to make your paper "pretty," then just go on newspagedesigner.com or newsuem.com, find what appeals to you and get inspired.
If you want to go deeper, then that takes a lot of work, time, careful thought and trial and error. It's always been my opinion that design/presentation is about the seventh or eighth most important aspect of any newspaper. Changing the way you deliver the news is going to impact so many other elements of the operation, and you must be respectful of those possibilities.
I've redesigned publications and started others from scratch. If you want to talk more specifically, feel free to PM me.
If you want to check out some great-looking papers, try:
* Boston Globe
* Portland Oregonian
* Toronto Globe and Mail
* San Jose Mercury News
* San Diego Union-Tribune
* Bend (Ore.) Bulletin (Small paper, but ambitious design)
* Lewiston (Maine) Sun Journal (Small paper, too, but an SND favorite)
Good luck.