Plans to turn a former care home in Wrexham into asylum seeker housing will not progress any further, it has been confirmed.