All my files are currently on my profile of the hospital server site. Will I be able to continue using this?

If these files are needed for your work, then it makes sense to migrate them into the Council’s file stores. This will be with the agreement of your respective Information Governance team.