The Hollyoaks star has died at 46 years old, his management has tragically confirmed