If it's nice outside, I would definitely suggest sitting at the red picnic tables to sip your drink. During filming, there's even a sign that reads "Storybrooke" on the wall, which is great for photo-ops.
Image Source: POPSUGAR Photography / Kelsie Gibson