It's cool if that's the rules of that cafe, especially if they're at a sidewalk table outside. I used to take my dog to work and then take him into the cafe and get him a cookie from the cashier. Everything was chill, and the owner had photos of regulars' dogs on the wall.

ETA: My experience with dogs in cafes was in a different state.