I haven't been but I believe Ann Arbor is a very desirable place to live. A thriving college town, very liberal, often appears in top places to live in the US type of surveys so that's a good start.
Whether you'd be able to work depends on what type of visa you'd get which is dependent on what type of visa your DH will get. If it's an L visa (intra company transfer), you will get a spouse L2 visa and you would be allowed to work. You would need to apply for an EAD card after you arrive to be authorized to work. This takes around 3 months to arrive and you can't work until it arrives. Do you work in a field where you could transfer easily?
If he's not going on an L visa, you may not be allowed to work. The visa is the most important thing to consider so if he gets down to the nitty gritty of being offered a job and negotiating terms, be sure that his employer is very clear about what type of visa he's eligible for and that they're going to pay for an immigration lawyer to process his application and get visas for the whole family. I would say it's possible to get visas for everyone in as little as 2-3 months, but a more realistic timescale would be 6 months.
Renting will be easy. A college town with companies who are are transferring employees from overseas should have a plentiful supply of rentals, everything from apartments to family homes. Your DH's employer may provide a relocation assistant to help with finding a home. If not, it's quite straightforward to do it yourself. In the US, school places are determined by address so you want to research the schools first, find the best school you can and then find a home within that catchment area. I would highly recommend a recce visit first to get a feel for the place and see if you can see yourself living there. Would it be walkable, or would you need 1 or 2 cars to commute to work, get around town?
Your standard of living will depends on what the salary will be. Read some of the other recent threads on here to see what the general consensus is about the cost of living in the US (there's a grocery thread on the go at the moment). It's expensive, no doubt about it. But if there's a significant salary coming in (min 6 figures), it's possible to live a nice life. With regards to your house in the UK, if you keep it and rent it out, the rental income is considered as income for the purposes of your annual US tax return and needs to be declared as such. That needs a bit of research to understand that side of things. You might need an accountant to prepare your tax returns.
It would be a wonderful opportunity to experience a different culture (and it is very different) but it's tough at the beginning establishing a new life and getting everything set up. How long do you think you might move for initially?
A couple of other thoughts:
Be sure you understand how the healthcare system works and how the insurance is paid for through salary and what the out of pocket costs would be for your family. Consider medical, dental, vision. Be sure to get full details from the employer as to what the insurance coverage is for the family.
Flying back to the UK can get very expensive especially at holiday times so be sure to factor that cost into your yearly budget if you think you'd be wanting to go back regularly to see family. I've seen families of 4 spend nearly $5000 just on flights to get home at Christmas to visit family.
In short, it would be an amazing opportunity but it's not for the faint hearted. If you're solid as a couple and are up for an exciting adventure and a bit of an emotional roller coaster along the way, go for it!