Councillors have clashed over plans for a north Belfast football pitch to be shared by two teams.