The smoking ban in public places is hailed a success by Wales' medical chief, but pubs warn of closures.