Charlotte will join a new model for supporting the arts and culture across the region after months of debate.