Council-run museums in Leeds are celebrating after new figures revealed they welcomed more than a million visitors through their doors last year.