I'm thinking about getting a Golduck, but is it worth it?
If this is in Gen 1, then maybe. There are a lot of Water-type Pokémon in Gen 1, and some are obviously better than others. I would say that the best Water-type in Gen 1 is Blastoise or Seaking. Blastoise has good stats, and due to the X Accuracy glitch in Gen 1, it makes every move hit. Seaking gets Horn Drill in Gen 1. Horn Drill is a guaranteed OHKO if it hits. So, I would say that Golduck is worth it. It can get Psychic moves which wrecks Agatha. Golduck isn't the best Water-type for Gen 1, but it's good.
No, it's not. I'm assuming you mean gen 1 from your tags, but Golduck was a little worse in gen 1, compared to other generations. It's base stats in gen 1 were
HP: 80 Attack: 82 Defense: 78 Sp. Atk: 80 Sp. Def: 80 Speed: 85
Total: 485
However, in generation 2, it got a buff in special attack. gen 2 stats:
HP: 80 Attack: 82 Defense: 78 Sp. Atk: 95 Sp. Def: 80 Speed: 85
Total: 500
The gen 2 stats are the current stats for Golduck. For your water type, I would recommend Blastoise, or Starmie. Compared to these water types, Golduck would not stand out. Espescially with the crazy high stats for some water type Pokemon in gen 1.
Source