Is heap a common noun or a collective noun?

It is both. 'Common nouns' and 'collective nouns' are not mutually exclusive categories. That is like asking 'Is fire red or hot?'