Okay, so my to-be fiance have been discussing some wedding details and he seems to be pretty firm on not having alcohol. I'm completely on board with that, however... I have a lot of friends and family that drink religiously and I'm extremely worried that they will be bored.

I would still like for there to be dancing and for everyone to have fun! I have heard about the espresso bar and love that idea! What I am needing help on is sort of an idea for a timeline with activities and transitioning into the alcohol-free reception? I noticed a lot of wedding timelines had cocktail hour and what not.
Re: *Dry Wedding Reception*
There's plenty of cool mocktails you can do - italian soda bar, smoothies, etc, but they'll be more spendy than punch, soda, coffee.
Are you guys engaged (as in, have mutually agreed marriage is in the near future) or not engaged?
Anyway, I've been to a number of dry weddings. I'll warn you - prepare for your reception to be shorter and a little less rowdy. I've never seen a dry reception last later than 9. If you're ok with that, go for it. There's nothing wrong with a dry wedding.
Cocktail hours don't necessarily have to serve cocktails; they are just designed to eat up time and host your guests while you take pictures. Just serve non-alcoholic drinks and apps during that time. Mocktails, iced tea, lemonade, Italian sodas, and coffee bars are all great alternatives. As for the timeline, you'll function how pretty much other wedding goes: mocktail/refreshment hour, dinner, toasts, dances, open up the dance floor (or some variation).
There is no difference between a reception with alcohol and a reception without alcohol.
There is no difference except for what @PDKH said. That a reception without alcohol will probably break up sooner than one with alcohol.
You can still have dancing without alcohol. You might serve "mocktails" instead.
I'm not sure how much of the suck-factor was the lack of music and how much was people complaining about lack of booze though (tacky though it was).
You say that your friend and family drink religiously, so this might be something to worry about, but as long as you've got SOMETHING they can do...