Unions have signed an agreement with Bradford City of Culture aimed at ensuring creative workers engaged in the programme will receive decent pay and conditions.