From the outside, the UK’s regional museums may look to be in rude health. But how have recent funding cuts affected what’s happening behind the scenes?