Brush palette, Expanded View (so you see the settings), Shape Dynamics, set the Size Jitter dropdown to Fade, and change the number to affect how long it takes to scale down. This works without a tablet. Best to get a pressure-sensitive device though, the Fade method is very tedious.