When I work from cafés I try to spend at least a few € every two hours, and avoid places that are overly busy (I don't like noise, but also if there's spare seats then I'm not costing anyone customers by sitting in one all day). Feels like common sense really - don't be an asshole.