The one at Epcot includes alcohol and costs a good bit more than MK. It's also standing only. At MK you get a seat, but in order to see the fireworks well you may have to go stand by the area's railing anyway.
It's not near Rose & Crown, it's on the plaza between the two shops, right as you walk in from Future World.