If you hand in your notice, you might as well leave.

Managers are people too and can get really grumpy at your 'oneuppance'. They may give you a raise just to fire you a few months forward, making you lose your currently better offer (If you handed a notice, that was actually what you transmitted - "I want out").

Happens a lot more than one might expect.