Is herd a preposition

No, it is not. It is a collective noun (a group of animals) that may also be used as a noun adjunct (herd behavior, herd management). It can also be a verb meaning to collect or move animals in a herd.