Depends what kind of look you want? Do you want a sea-side cafe, or one close to town, or one near the town plaza? I have mine right above the plaza, between it and the entrance to the shops.
I would try and back it on to something or put it on one of the small spaces at the edge of town. It takes up so much room, I find it a bit of an annoyance. I've placed mine in the corner of town, backing on to the river and the cliff at the left side. It's just difficult if you place it in the middle of open space as it can limit what you can do around it, in my experience at least, I'm sure more creative people would be able to figure it out though I'm just not very imaginative