Your residence visa will be dependent on your sponsor. If employer is your sponsor then you'll get Fujairah visa. If you get a student visa, I guess you'll get a
Dubai visa (I'm not so sure about student visas - does the college sponsor you?). The residence visa does not restrict you to living in the emirate in which it's issued, you can live anywhere.