I have done it with two particle systems. One static for the piles in the hourglass, which are modeled objects with static particles at the surface and an secound particle system for the falling sand, using the same very simple pre-modeled sand partices.