Can a collective noun be a common noun?

Yes, collective nouns would always be common nouns.

For example:

  • a flock of birds
  • a group of grouse
  • a collection of objects
  • a herd of bison
  • a shoal of minnows
  • a crowd of people