If you want to be a psychologist you do a psychology degree.
If you want to be a therapist, the psychology degree isn’t necessary. A vocational degree in mental health nursing, social work or occupational therapy would probably get you there faster as these are the professions most likely to be recruited to do therapy training, more likely than psychology probably.
Psychology is a long hard journey. May involve quite a few years post grad to get anywhere near the doctorate. Doing the degree at a place like Hull or York may get you there considerably faster but no guarantees. You need to be quite clear about what you want before you sign up for any course of study. So many people I see going for psychology would be much better suited to other routes that they just don’t know exist so make sure if you end up on the psychology route that you know where it is you’re headed.
As to where you do it, nobody will care in principle where you went. But placements done as part of a university degree don’t always count for as much as you might think so don’t choose it just for that. You want to take a holistic approach to your course choice and choose it based on where you think you’ll be happiest, where you think you’ll do best and where you think you’ll get the best experience. Not because of the name on your certificate and not because of one module or one placement.