I know that the arabs didn't like it at all, but what was the attitude to the plan from the US, the USSR and the European Countries? Did anybody believe the plan to be viable?
Well, the US was a strong supporter publicly. It assisted the Zionist groups in getting the plan passed, sometimes through methods that are reported to have been less than acceptable. These included threats, bribes, and strong-arms. President Truman was good friends with leading Zionist Chaim Weizmann, who spoke to Truman numerous times to influence policy on the plan, including to convince Truman to support keeping the Negev desert in the Jewish state.
The USSR was also a supporter, which sealed the superpower vote for the most part. As this shows, the supporters and opposition can be seen by the votes at the bottom. The USSR believed it could make a friend out of the presumed Jewish state by most accounts, since Zionism was dominated by the semi-socialist Labour Zionists. The Soviets also hoped to ruin British influence in the region, of course, and the Soviet bloc (the Czechoslovakians) were particularly important in getting Israel the arms it needed to win the war, most of which were delivered and organized during the first Truce of the war of 1948. This would change shortly after the state was established, with the USSR instead adopting more anti-Semitic overtones, and as the USSR moved closer to Arab states.
As for European countries, the British were the main player in Palestine, but refrained from doing any type of negotiating or pushing on the resolution. They mostly stayed out of the issue publicly, and abstained on the vote. Other European countries supported the resolution, as the vote counts show, and were likely swayed by superpower support. Only Greece voted against from Europe, and Yugoslavia (along with the aforementioned UK) abstained.
On the other hand, Belgium, Byelorussian SSR (later Belarus), Czechoslovakia, Denmark, France, Luxembourg, Netherlands, Norway, Poland, Sweden, Ukrainian SSR, and the USSR all voted for the resolution.
Just to sort of sum this up, let me give you a breakdown of where some of the countries lay and how they were influenced, as far as Europe, according to Benny Morris:
Belgium, Netherlands, Luxembourg, and Denmark would follow France. Only intense lobbying by Zionists and "pangs of Holocaust-related conscience" convinced the French to tell their delegation to vote yes.
The Netherlands had also expressed reservations, as a result of their problem of a heavy Muslim population in Indonesia (16 million). However, as their representative to UNSCOP came up with the plan (in part, of course, as part of the committee), they stuck to a "yes" vote.
Greece was pressured heavily by the US via lobbying, but resisted and voted no (reasons unclear to me).
Britain only influenced countries privately in the days leading up to the vote, as mentioned above, and publicly told its delegates not to influence anyone. They abstained.
The Soviet bloc voted with the Soviets.
Yugoslavia was, according to Morris, a "partly Muslim" country. While the country did indeed have a sizable number of Muslims, it was not more than 20% by any count I've found. Still, this likely had an influence. Yugoslavia stood on the precipice of expulsion from the Cominform, which occurred in June 1948 (half a year or so after the vote), for other reasons. At any rate, what reason they had for disagreeing I also have not found. I imagine it's in the records of debate, but I can't seem to track those down online.
I haven't found records on other European states or any mention of them, in most of the books I have. I'm sure I could, or I'd go through the UN debate records if I could dig them up somewhere online (I don't think they're online through the UN, they'd have to be found elsewhere, maybe I'm wrong), but that's a pretty solid indication in my opinion. US-dependent countries (besides Greece) got the carrot or the stick (or genuinely believed in partition), Britain stayed out of it and privately counseled countries, though Australia and New Zealand (expected to follow the UK) didn't follow their advice, the Soviet countries besides Yugoslavia follow the Soviet line, and various other countries (ie. Muslim, Catholic, or otherwise unaligned or indifferent) either abstained or voted no. I could probably go into more detail on the other countries if you want.