I thought about some goldfish but heard they poo loads

Any advice regarding what ones to get... also need a decent light for tank.

Thanks