Councillors in Merthyr Tydfil have voiced their support for a “once in a lifetime” £300 million ski slope development – going against the advice of council officers.