Hugh visits a fun-packed modern city mansion, an arty Welsh 16th-century manor house and a 40-room stately home preparing for the new generation to move in