It depends on your level. I recommed you this guide: http://forums2.battleon.com/f/tm.asp?m=15399196 . For every question about weapons for your lvl. If you want to know more about the weapon, just click on it's name.
You can get the legendary magma sword for 150 gold in the weapon shop in oaklore keep and the flambe in yulggar's shop. You also can get a DA weapon called drake's blessing and other non DA fire weapons at the fire cave near warlic's tent. Note: it might take a lot of tries until you get the drake's blessing.
firstly if you have not unlocked the locker saga in Falconreach then you need to unlock it. If you have unlocked it then click on the button in the top right corner of the fishing wharf located to the east of Falconreach. Once you have clicked on the button then it will show a short clip, then after click dunk and you will arrive at a city underwater. Look at the sign post,head towards the town from where the sign post is pointing where it is. Go straight ahead past Aquella then go to the weapon store on the left of you.Note:you must be level 20 or higher to use one of the water weapons. Hope this helps.
in the secret water cave behind the waterfall, if you have a dragon amulet
Just buy it, or go to a quest for a drop.
To get a level 9 water staff you have to get all four quadforce pieces and fight Ganana or whatever the name is.
Hope i helped
The Locker, found in the teleport gate in Falconreach has probably the best water weapons. (Probably because it's UNDERwater.)
behind Robina
go to the pvp tournements
buy it
Go to Aeris Battle thing in the sky,get a trophy,and buy the level 8 water weapon. its a very good weapon and its easy to get
defeat him or buy it at ragnar but you need to be a member to use it
Unlock the first shop in pvp. youll get water weps there.
you have to say what weapon first
you have to have a certain blacksmithing level from yulgar. then you buy materials of him and u make a wep
Doom or Destiny Weapon
if you eant a a destiny weapon
The novice shop. You unlock it by earning a trophy (defeat 5 opponents).
Doomkitten is the boss you must fight, lest you getting a really good water weapon, yw
A Doom or Destiny weapon, see Artix or the Mysterious stranger.
go to shadow of the wind village and then thre you will find a person he will train as a minja