I'm pretty sure the default Twitter app supports notifications on users tweets.