There are the following styles of weapons in Fable:
Longsword
Katana
Pickhammer
Axe
Mace
GreatSword
GreatHammer
Greatmace
GreatAxe
_
Longbow
Crossbow


And there are the following types of weapons:
Iron
Steel
Obsidian
Master
_
Yew
Oak
Elbony
Master
_
Legendary

Legendary weapons are found in lots of different places, including treasure chests, temples, quests etc. Some legendary weapons are listed below.

Cutlass Bluetane: Found in the demon door at GreatWood Caves.
Sentinus: Received by donating large ammounts of gold to the temple of Avo.
Sword of Aeons: Obtained by defeating Jakc of Blades the first time and killing your sister.
Avo's Tear: Obtained by destroying the Sword of Aeons and reading Maze's journal.
Skorm's Bow: Obtained by donating several people to the Chappel of Skorm.
Arkon's Crossbow: Found at Darkwood Lake in a treasure chest.
Frying Pan: found at Orchard Farm after receiving all of the treasure clues.
Ronok the Axe: Found in the demon door at the Grayhouse.
The Harbinger: Found in the stone at the Temple of Avo
Murren Greataxe: Silver key chest in Hook Coast.
Murren Greathammer: Found at Heroe's Guild in 20 key chest.