Becoming a Manager by Linda Hill. Not a how-to, but it gives you a preview of the challenge and the blind spots you might have as you become a manager.
Another that I haven't read but has been recommended to me is The Manager's Path.
In addition to others already mentioned, "Becoming a Manager," by Linda Hill: follows a group of new managers for a year, discussing how their understanding of their role changes. Absolutely great - for a long time I kept a home copy and a work copy. Follow-up "Being the Boss" is also good. And "The Leadership Pipeline," by Ram Charan, Stephen Drotter, James Noel: what you need to learn/change to succeed at each different level of management.