Northamptonshire's Ireland international Niall O'Brien will join Leicestershire for the start of next season.