The second hand smoke issue is very overblown. However, it is beyond annoying to visit a place of business or home where the occupants regularly smoke inside. It takes a very stout air cleaning system to keep the air reasonable fresh in a bar that allows smoking. Much better to set up a smoking patio outside, where patrons can enjoy their smoke without annoying and chasing away the rest of the potential customers.
Much better to let private business set their own policies, and let the market decide whether it's a viable economic plan or not.
If you don't like being in areas where people are allowed to smoke, don't go there. Take your business elsewhere, because there are plenty of businesses which cater to nanny-staters and their ilk...