North American family offices are approaching the upcoming transfer of wealth to the next generation with cautious optimism. A report from RBC and Campden highlights