A Welsh local authority has voted to divest its local government pension scheme (LGPS) from fossil fuels as it moves towards more sustainable investments.