The catapult only appears in siege combat, and can only attack castle walls and other fortifications. Every hero has one, it cannot be soldsold, given away, unequipped, or left behind, and if the catapult is destroyed during combat, it will reappear once the combat phase is over.
So from that I assume that you can't buy another one.