Original question: ... will be rain tomorrow ...
Correct phrases:
THERE will be RAIN (noun) tomorrow. [= IT will RAIN (verb) tomorrow.]
IT will be RAINY (adjective) tomorrow. [= IT will be A RAINY DAY tomorrow.]
Incorrect phrase:
___ will be rain tomorrow PERIOD but it won't too heavy.
Correction:
THERE will be rain tomorrow COMMA but it won't BE too heavy.
Second question: It will be sunny ...
Correct versions:
It will be sunny in X tomorrow.
It will be sunny tomorrow in X.
Tomorrow, it will be sunny in X.
As Som mentioned, all of these are correct.
The most common pattern in English is [subject/verb/objects] [place] [time] [purpose/reason].
Example:
My wie and I ate dinner at her favorite restaurant on Friday because it was her birthday.
My wie and I ate dinner <<== subject/verb/direct object
at her favorite restaurant <<== place
on Friday <<== time
because it was her birthday. << reason
For style, other combinations are correct.
On Friday, my wife and I ate dinner at her favorite restaurant because it was her birthday.
For her birthday, my wife and I ate dinner at her favorite restaurant on Friday.