A giant sturgeon that has massively outgrown its environment over a quarter of a century has been given a new lease of life by its owners.