What happens when you get all the small weapons in assassins creed 2

Nothing "happens." You just unlock all small weapons and can access them in Villa Auditore to use them as you please.