I have been wondering do water candles work if you place them on the floor or on the table, or if they only work if it is in your hand.
According to Terraria's official wiki page on Water Candles:
They produce light like a regular torch or candle would. If you have them on tables as props, they produce some lovely spooky lighting. However, they don't increase the spawn rate like this.
To increase the spawn rate with a water candle, hold it in your hand. It can't just be in the top row of your inventory - it must be the currently active and held item.
Keep a weapon handy so that you can swap back and forth between your water candle and weapon as necessary. You can't hold both at the same time, but you can at least run around luring enemies out with your water candle, attack them all, then return to luring enemies out.
According to the disassembled code (188.8.131.52.1), placed water candles also affect spawnrate and max spawns. This effect is separate from holding the candle in your hand and will stack with it. A single placed water candle is enough and only one matters.
Both effects are the same and when stacked (holding a candle and placed a candle) spawnrate is increased by 78% and maximum spawned enemies is increased by 125%.