Vale of Glamorgan Council is one of a number of UK public bodies that have distanced themselves from the social media platform owned by Elon Musk